Forum Discussion
Card Visual to display applied filter
So I have a report with a date filter applied and I would like to display the filter range in a Card as part of the report. Using a measure I have able to show the applied filter values ie. 03/12/19, 27/01/19, 17/12/19 etc but I can't get it to display the actual filter itself.
I am using Advanced filtering to specify a range for example "is on or after 01/12/2019 AND is before 01/02/2020"
Any thoughts on how this could be achieved?
Thanks,
Hey Anonymous
One of these threads should have your solution:
1. https://community.powerbi.com/t5/Desktop/Display-slicer-values-selected-in-card/td-p/559294
2. https://community.powerbi.com/t5/Desktop/Display-a-range-of-dates/td-p/141013
If this helps please kudo.
If this solves your problem please accept it as a solution.
Show this measure on card
Measure =
var _min = minx(date,date[date])
var _max = maxx(date,date[date])
Return
_min & " " _max
If needed use format. like format(_min,"mm/dd/YYYY")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
4 Replies
Show this measure on card
Measure =
var _min = minx(date,date[date])
var _max = maxx(date,date[date])
Return
_min & " " _max
If needed use format. like format(_min,"mm/dd/YYYY")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on LinkedinI initially thought that this was resolved however all of the suggestions so far don't quite resolve the issue. for example, I want it to display exactly what is entered into the advanced filter ie. 01/12/19 - 01/01/20 however all of the suggested solutions only show the first and last filtered values so it may show 04/12/19 - 19/12/19.
I need to display the full date range and not just the highest and lowest values once the filter is applied, any ideas?
Hey Anonymous
One of these threads should have your solution:
1. https://community.powerbi.com/t5/Desktop/Display-slicer-values-selected-in-card/td-p/559294
2. https://community.powerbi.com/t5/Desktop/Display-a-range-of-dates/td-p/141013
If this helps please kudo.
If this solves your problem please accept it as a solution.