All in Data Visualization
It’s frustrating that in Power BI re-naming measures or moving them to another table will break any visuals using them in reports. Likewise, Power BI does not have a feature to hot-swap measures in visuals, to retain formatting or save time. Here I will show you an easy way to replace multiple measures in a Power BI report, including those used in “broken” visuals. Fix all broken visuals in Power BI reports using this method!
In this article, we look at some tips to best use pbi-tools and how to automate pbi-tools execution in the background, using Power Automate Desktop flows.
pbi-tools is a command-line tool that enables Source / Version Control of Power BI (thin) reports and datasets. Much like the folder structure generated by Tabular Editor, pbi-tools creates a Report Layout structure based on files in the .pbix. In these articles, we go into the background of this tool & how to use it.
An important note if you are using Sensitivity Labels - files with Sensitivity Labels are currently not supported with pbi-tools. More info on that at the bottom of the article.
The default Cards & KPI visuals are frequently the first visual a report user will see. It is thus important that they contain meaningful values. Unfortunately, for many users, a (Blank) is not meaningful, either because it is not understood, or they expect to see 0, instead. Here I explain how you can easily hide these blanks with conditional formatting, or a few methods to replace the (Blank) with 0.
In this article, we examine a method to automatically monitor & test data quality in Power BI by setting up a composite model to detect data changes.
In this article we look at how to get Microsoft Tasks / Planner data into Power BI, to make analytical reports from our operational Planner boards.
In this article we look at a method for creating waffle charts in Power BI with the default visuals.
In this article, we look at a method to format a single data point in a Power BI visual. Specifically, we look how to label the latest data point in a line chart. This method also works with individual formatting of other data points.
In this article we look at how to have dynamic dimensions in Power BI so that users can choose fields that appear on visual axes, table rows or other categorical elements.
In this article we examine a method to create dynamic hierarchies in Power BI. This is particularly useful for creating ‘details-on-demand’ matrixes; interactive pivot tables in Power BI.
In this article, we look at a way of creating a folder-tab navigation experience using the KPI and Card visuals. Users click on the KPI or Card and then get more details for that metric.