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 

 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

 

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 ,

  The required file is attached below, here I tried the above said methods but, I'm not getting the required answer.So, I'm reposting the requirement again the Slicer which is in blue colour should display the recent Monday date as default and it needs to give the data from earliest date till Monday(If today is Monday) or need to give data till last Monday of present week. 
Demo_file 
Thanks in advance,
Jetlee

  • 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.