Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date Default selection till Yesterday

Hi Power Community,   I have a date filed in Fact table wihich continas data since 2005 till yesterday. For filtering purpose I am using Date dimention which contians 2005 till 2025. here when eve...
Data Protection
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    According to your description, you want the data, and Slicer both show only the current year till yesterday. If you just want to show data from the current year till yesterday, you can try this measure:

    Measure =

CALCULATE(MAX([Amount]),FILTER('Table',YEAR([Date])=YEAR(TODAY())&&[Date]<=TODAY()-1))

    And place the measure to the chart, like this:

       

    If you want to set default value for a Slicer, I think that you can try the Power Slicer . It’s a custom visual which supports adding default value to Slicer using JavaScript. You can download it and try to figure out how to realize it.

     

    Best Regards,

    Community Support Team _Robert Qin

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

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

According to your description, you want the data, and Slicer both show only the current year till yesterday. If you just want to show data from the current year till yesterday, you can try this measure:

Measure =

CALCULATE(MAX([Amount]),FILTER('Table',YEAR([Date])=YEAR(TODAY())&&[Date]<=TODAY()-1))

And place the measure to the chart, like this:

   

If you want to set default value for a Slicer, I think that you can try the Power Slicer . It’s a custom visual which supports adding default value to Slicer using JavaScript. You can download it and try to figure out how to realize it.

 

Best Regards,

Community Support Team _Robert Qin

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