Blog posts about Power BI desktop
Do you want to check the features which will be developped during the next months ? Please read the Power platform roadmap. Check and vote for ideas supporting these evolutions. How to check the Power platform roadmap Click on the link down below and select the latest roadmap. The document is huge as it covers…
Export Power-BI desktop data to Excel with R. This R script exports a Power BI table automatically to an Excel (xlsx) file. This works from your report with an ‘Export’ button. The maximum number of exported lines is 150 000. How to export Power-BI desktop data to Excel Install R and R studio. Please have…
Once you know your report is filtered having a look at the green light, you expect to get more details. So add a tooltip to display applied filters. How to add a tooltip to display applied filters Create a tooltip page, name it ‘TT filters’ and hide this page. See this blog post if you…
To understand properly our data, the very first thing we need to do is to perfectly know the filters applied to data. There are many ways to filter data (in the data source, in Power Query, in report/page/visual filters, slicers, …). So if you don’t understand your filters, you don’t understand your data. I will…
When we use a report, it’s important to know if users applied filters. So, you can display a light when data is filtered. How to display a light when data is filtered First, you create a measure to detect an active filter : And you create an other measure to detect inactive filters : And…
There are different ways to filter data in Power BI reports. My favorite one is to create a specific filter page containing many slicers. These filters will be applied to the whole report or to a part of it. In next posts, I will show you how to display the applied filters in pages. How…
Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add a refresh date in a visual. How to add a refresh date to your report Create a table using ‘Home/Enter data’ menu and name it as you want. Add a…
A really efficient way to get immediately more insights is to use a tooltip page in your report. I consider it is a good practice if you don’t abuse of it. The content of the tooltip may be static or dynamic depending on the value which is hovered. How to add a tooltip page in…
It’s sometimes useful to compare visuals functionalities. This report is only made for that : compare similar visuals with the Visuals test report. Download the report : Visuals test report More about visuals : Visuals category
I encountered some problems to get Power BI map visual working properly. So I share here the way I do using few tips for map visual efficiency How to Create a calculated column with DAX concatenating a city and a country. Separate them with a space, a comma, a space (do not do it in…
