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 the date range in the tooltip
- Edit the ‘Selected filters’ measure and add a new variable (Filtered_date)
Selected filters =
VAR CR_LF = "
" // This is a simple carriage return
VAR Filtered_date = "- Orders dates from " & FORMAT(MIN(Orders[OrderDate]) ; "dd/mm/yyyy") & " to " & FORMAT(MAX(Orders[OrderDate]) ; "dd/mm/yyyy") & CR_LF
VAR Company = IF(ISFILTERED(Customers[CompanyName]) ;
"Company = " & CONCATENATEX(ALLSELECTED(Customers[CompanyName]) ; Customers[CompanyName] ; " , ") & CR_LF ; "")
VAR Category = IF(ISFILTERED(Categories[CategoryName]) ;
"Category = " & CONCATENATEX(ALLSELECTED(Categories[CategoryName]) ; Categories[CategoryName] ; " , ") & CR_LF ; "")
VAR Product = IF(ISFILTERED(Products[ProductName]) ;
"Product = " & CONCATENATEX(ALLSELECTED(Products[ProductName]) ; Products[ProductName] ; " , ") & CR_LF ; "")
RETURN Filtered_date & Company & Category & Product
You may adapt the date format to your needs.
From now on, the date range filter will appear in any page you desire.
Tips
You may even create a dedicated measure for the date range filter and display it in all your pages or in the title of some visuals.
Here is the pbix file of the demo : download demo ‘Report filters.pbix’
This post is a part of a series : see the series