Sometimes, it is useful to compare the same data from two columns. So, here is a simple function to do it in Power Query. The columns may be in the same table or in different tables. It provides data profiling in a very simple way. How to compare the same data from two columns in…
You can add data in a table or in an Excel file from your reports. Additionally, you can include a small application. The way to achieve these goals is to add a PowerApps visual. So, please watch this 4 minutes video to add data in a table from your reports. https://www.youtube.com/watch?v=3eiUR8Lo4i4&feature=youtu.be For more interactions from…
Often, we need to look for a table or for a specific column in the database. Do you know it’s possible to create a simple query to visualize your database schema within Power Query ? Very few steps for great results. How to display database schema (first method with data preview) Add a blank query…
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…
Often we look for the documentation of a function or we even look for a function. We may use Microsoft documentation (https://docs.microsoft.com/fr-fr/power-query/). But there is an other way much more comfortable for my needs: access to M functions documentation within Power Query How to Add a blank query and name it ‘Shared’ Open the advanced…
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…
