Forum Discussion

JakubHa's avatar
JakubHa
Frequent Visitor
9 years ago

Last 3 Months Slicer

Hi, I`m trying to create a Slicer with Last Month, Last 3 months and Overall. I tried one Dax formula described here: Power BI – Time Period Slicer for Last 7 Days,Last 30 Days.. – Analytics A...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dear JakubHa,

 

Have you try What-If parameter?

You can create new Parameter type Number, it'll use for selected number and refresh data with last 1,2,3,....9 month.

Parameter Value = SELECTEDVALUE(Parameter[Parameter], 3)

 

Then make measure, filter it by some Operation with "Parameter Value".

 

Topic about Parameter: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#whatIf

 

If you need a day drill option, you can use Custom Visual "TimeBrush". You can drag mouse to select a range or move it.

 

 

JakubHa's avatar
JakubHa
Frequent Visitor
8 years ago

Hi Anonymous,

 

Thanks for your suggestion! I`ll try it out and let you know if that works fine for me :)

 

Greetings,

Jakub

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Dear JakubHa,

     

    Sure, I'm waiting for your result. If you get problem, we can discuss more :)

     

    Regards,

    ManNVSM.