YTD Selector Slicer shows data but MTD and QTD slicer doesn't

[Niels_T]

Hello,

I wanted to make a selector where I can select YTD, QTD or MTD.

I followed some articles and posts on this forum and this is what I eventually came up with:

I made a new table called "SelectMeasure" that looks as followed:

I made a measure within that table called "SelectorNum" which does the following:

SelectorNum = MIN(SelectMeasure[SelectorNumber])

I then made my MTD, QTD and YTD measures:

SALESMTD = TOTALMTD(SUM('Credit Memo + Invoice'[Amount]),'Calendar'[Date])

SALESQTD = TOTALQTD(SUM('Credit Memo + Invoice'[Amount]),'Calendar'[Date])

SALESYTD = TOTALYTD(SUM('Credit Memo + Invoice'[Amount]),'Calendar'[Date])

After that I made a Selector measure within my sales table:

Selector = SWITCH([SelectorNum]

, 1, [SALESMTD]

, 2, [SALESQTD]

, 3, [SALESYTD]

)

I then use the "SelectorMeasure" for my graphs and the "Selector" for slicers. 

Now the problem that I have is that when I select YTD, it seems to work but whenever I select QTD or MTD it just doesn't display anything.

[Niels_T]

@amitchandak @v-xulin-mstf 

It seems like the problem is more with my measures then the selector slicer itself. Thanks for all the links and information though!

[v-xulin-mstf]

Hi @Niels_T

I am glad to know that your issue has been solved, please adopt your solution if you can so that it can help others.

Best Regards,

Link

[v-xulin-mstf]

Hi @Niels_T

You can refer this to meet your need:

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

You can also refer this related post.

Best Regards,

Link

[amitchandak · Accepted solution]

@Niels_T , Refer my video on the same topics

https://www.youtube.com/watch?v=b9352Vxuj-M

Based on the value you need to change time intelligence

Or refer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...