Forum Discussion

saiprathapdp's avatar
saiprathapdp
Frequent Visitor
5 years ago
Solved

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's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity 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.