Forum Discussion
Card Visual to display applied filter
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
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
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?
Hey Anonymous
Just add the SELECTEDVALUE() function to soem of the suggestions.