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.
Don’t forget to add your filtered date range in the tooltip. This is one of the most important filter to display. How to add your filtered date range in the tooltip Edit the ‘Selected filters’ measure and add a new variable (Filtered_date) You may adapt the date format to your needs. From now on, the…
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…
