Forum Discussion
saiprathapdp
5 years agoFrequent Visitor
How to display dynamic filter value in dashboard
we want to show the dynamic filter value date in powerbi desktop as below screenshot.
The filterd data will change every month so the date should update auomatically in the card value
Ex:- Azure market place Last calender month 5-1-2
Hi saiprathapdp ,
Please create a measure like below:
Measure 2 = "Azure market place Last calender month "&CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'[Date]))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- V-lianl-msft
Community Support
Hi saiprathapdp ,
Please create a measure like below:
Measure 2 = "Azure market place Last calender month "&CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'[Date]))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.