Card Visual to display applied filter

[Anonymous]

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,

[Anonymous · Accepted solution]

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.

[amitchandak · Accepted 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

[Anonymous]

I 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?

[Anonymous]

Hey @Anonymous 

Just add the SELECTEDVALUE() function to soem of the suggestions.

[Anonymous · Accepted solution]

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.