Skip to content
Small logo
Twitter Linkedin
  • Power BI services
  • The BI Power toolsExpand
    • Power BI Sidetools
    • Power BI assistantExpand
      • Power BI assistant
      • Power BI assistant troubleshooting
  • Power BI desktopExpand
    • Report filters
    • Translations
    • Data export
    • Visuals
    • Tooltips
    • Actions within reports
    • Futurist features
    • Other
  • Power Query
  • LinksExpand
    • Blogs, Web sites, videos
    • Power BI trainings
    • Tools
    • Power BI model documentation for free
    • Q&A
    • Visuals
    • R scripts
Small logo
Twitter Linkedin

Report filters

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.

5. Add your filtered date range in the tooltip
Report filters

5. Add your filtered date range in the tooltip

ByDidier TERRIEN 3 May 201916 December 2020

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…

Read More 5. Add your filtered date range in the tooltipContinue

4. Add a tooltip to display applied filters
Report filters

4. Add a tooltip to display applied filters

ByDidier TERRIEN 4 February 201916 December 2020

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…

Read More 4. Add a tooltip to display applied filtersContinue

3. Display filters applied to data
Report filters

3. Display filters applied to data

ByDidier TERRIEN 3 February 201925 March 2021

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…

Read More 3. Display filters applied to dataContinue

2. Display a light when data is filtered
Report filters

2. Display a light when data is filtered

ByDidier TERRIEN 2 February 201916 December 2020

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…

Read More 2. Display a light when data is filteredContinue

1. Add a filter page to your report
Report filters

1. Add a filter page to your report

ByDidier TERRIEN 1 February 201925 March 2021

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…

Read More 1. Add a filter page to your reportContinue

Categories

  • Power BI assistant
  • Power BI desktop
    • Actions within reports
    • Data export
    • Futurist features
    • Other
    • R
    • Report filters
    • Tooltips
    • Translations
    • Visuals
  • Power BI Sidetools
    • Custom analyser
  • Power Query

Tags

augmented reality compare columns custom analyser data database data cleansing data matrix data profiling db scheme dedupe distinct documentation duplicates excel export external tool filters hololens interactions issue m map model powerapps power bi assistant power bi desktop power bi sidetoools power query R refresh date roadmap search shared slicers table tooltip translations troubleshooting tutorial url username visuals visual studio code
Search
  • About
  • Contact
  • Subscribe
  • Sitemap

© 2025 The BI Power

Small logo

 

Scroll to top
  • Power BI services
  • The BI Power tools
    • Power BI Sidetools
    • Power BI assistant
      • Power BI assistant
      • Power BI assistant troubleshooting
  • Power BI desktop
    • Report filters
    • Translations
    • Data export
    • Visuals
    • Tooltips
    • Actions within reports
    • Futurist features
    • Other
  • Power Query
  • Links
    • Blogs, Web sites, videos
    • Power BI trainings
    • Tools
    • Power BI model documentation for free
    • Q&A
    • Visuals
    • R scripts