PowerBI Example with YTD, MDT and QTD slicer or buttons

[mikebi]

Hello,

Does anyone have an example of how to create a power bi pbix file with YTD, MTD and QTD with year and month selections?

Either using a slicer or button is fine.

Thank You,

Michael

[Ninja_Powered]

Does the inbuilt slicer functionality work for what you need? If you insert a slicer then change it to relative date in the slider settings then the user can select 'this week' 'this month' & 'this year'.

[mikebi]

I really want it to say 'MTD', 'YTD, 'QTD' with user selection.

[v-yiruan-msft · Accepted solution]

Hi @mikebi ,

Please review the following links, hope it can help you solve the problem.

Custom Date Period Selections in Power BI

Solved: Slicer MTD, QTD, YTD to filter dates using the sli... - Microsoft Fabric Community

Final Value 1 = 
IF(HASONEFILTER(Table[CalcType]),
    SWITCH(SELECTEDVALUE(Table[CalcType]),
        "MTD", [Measure 1 MTD],
        "QTD", [Measure 1 QTD],
        "YTD", [Measure 1 YTD]
    ),
   BLANK()
)

Best Regards