Power BI

With all the craziness in our lives due to coronavirus, the reliance today on facts is more important than ever. To help you stay safe I thought you would appreciate this tutorial to learn how you can build your own reliable Power BI report that can analyze the confirmed infections, recovery and death rates of …

This blog post shows how to use the Microsoft Teams Live Events to schedule events that the public can attend and watch sessions.

When you create a report it’s highly likely that you’d like to copy other visuals’ formats from an already formatted visual using “Format Painter” tool in Power BI. Perhaps you already used this awesome tool available in Power BI Desktop. As you see in the tooltip shown while hovering over the “Format Painter” tool you … Continue reading Quick Tips: How to Copy Visual Formatting to Multiple Other Visuals in One Go Using Format Painter Tool in Power BI

Meet Lexio: A product that is reimagining how you'll think about data and analytics forever.

Learn how to automate and elevate data curation, provenance, and protection for improved data governance. Read the report: An Evolution in Data Governance.

March Gateway release

What to do when a Power BI report is slow? - How to analyze and solve Power BI report performance issues.

There are many ways to share the dashboards, reports, and datasets that you create in Power BI. Below I’ll compare all such options (there are twelve!). First make sure to have an understandi…

Much like the pieces on a chess board – to the novice, they represent individual units with different capabilities. Over time (or so I’m told) as experience is gained through tournament…

Back in 2018, when I wrote a detailed post on how to create nested display folders for measures in Power BI, I mentioned that unlike in Analysis Services it was not possible to make a Power BI meas…

Coronavirus Disease (COVID-19) is a new global problem. This is our overview of the early research and data on the outbreak. We update this page daily.

Demographic science aids in understanding the spread and fatality rates of COVID-19 Hosted on the Open Science Framework

When discussing how to make the public more graphically literate (“graphicate”) in recent talks about How Charts Lie , I've been advocating...

Play with a model of coronavirus in the U.S.

The other day a reporter asked me about my favorite visualizations about the coronavirus. I've been hesitant about the quality of many graph...

Sentiment analysis can be extremely useful across multiple verticals. Learn how to enhance Power BI by leveraging pre-built sentiment analysis models.

One of the common patterns of a data model is the subscription pattern. In this pattern, we have subscriptions (or tickets, or issues, or whatever else you want to call it) open date and close date. The way that this data is stored in a table makes it a bit challenging to get informative insight…

In 2008 I was hired to solve a problem. At this point almost 12 years later, the problem itself is no longer relevant[1]. While digging around on an unrelated task today I found this chart, which i…

Updated every few days

In this blog post, I'm sharing a technique to display text as values in a multi-row card and still have the special Card Title.

If you’re new to Power BI or consider yourself more experienced this reference sheet is for you. I collected all the MSFT Power BI links I feel are the most relevant to help you get ‘on your feet’. Feel free to print or bookmark this as a quick reference. I created this table for my […]

The drill through functionality is in Power BI for a long time and already made huge steps forward. Though, one of the most challenging things with this very valuable feature was the discoverabilit…

Grouping Basics You can find the Group By button on the Power BI Query Editor window in 2 places: In the result dialog box, you can choose your key columns and aggregates. The key columns will default to what columns you currently have selected: From here, you will get the grouped result: Custom...

COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose

In the previous article/video, I explained how to create dynamic bins by choosing the count of bins in a slicer in the Power BI report. In this article, I'll explain, how you can do it the other way around, which is by selecting the size of the bin, you will have bins and buckets dynamically…

Banding (or binning or grouping) is a scenario that can be implemented both statically and dynamically in Power BI. Dynamic banding means selecting the bin (or band) configuration, and the banding changes based on the user selection of the slicer. Imagine that we have a count of customers by their age groups, but then we…

One of the most common types of banding or binning is banding based on a range. Let's say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping…