Forum Discussion

Jetlee_V's avatar
Jetlee_V
Frequent Visitor
2 years ago
Solved

Power BI Slicer

Hi I'm new to power bi ,I need to get the latest date as default when the power bi desktop is refreshed using slicer chart.I tried some measure like LASTDATE and used in filter but the data is not re...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, Jetlee_V 

     

    Measure = IF(SELECTEDVALUE(Sheet1[First Monday])=CALCULATE(MAX(Sheet1[First Monday]),ALL(Sheet1)),1,0)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
2 years ago

Hi, Jetlee_V 

 

Measure = IF(SELECTEDVALUE(Sheet1[First Monday])=CALCULATE(MAX(Sheet1[First Monday]),ALL(Sheet1)),1,0)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jetlee_V's avatar
Jetlee_V
Frequent Visitor
2 years ago

Hi v-zhangti ,

   This is relevant answer but still I need the slicer should have all other dates among them the most recent monday should be selected as default ,but still thanks for helping for the answer that I was searching .Thanks for ur help v-zhangti  and for 123abc  for the before response.