Dax for YTD,QTD,WTD,DTD, Half Year

[Sowmiya]

Hi Community,

Need DAX for YTD, MTD, QTD, WTD, DTD, Half Year in single slicer visual. Here In my case I'm having date field in which slicing measure to be calculated.

Thanks In Advance,

Regards,

Sowmiya

[v-danhe-msft]

Hi @Sowmiya,

Based on my research, I am afraid you could not use measures as slicer, but you could refer to using bookmarks and buttons to show your visual in differnt Scenes:

Reference:http://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Regards,

Daniel He

[CheenuSing]

Hi @Sowmiya

Can you share some sample data and solution you expect. How many slicers are you going to have ? A single slicer which has options for YTD, MTD, QTD,WTD,DTD, Half -Year ???

Cheers

CheenuSing

[Sowmiya]

Hi @CheenuSing

Yes, I need single slicer for YTD,QTD,WTD,DTD, Half Year.  

Following are my datasets

I need function for following slicer format

Thanks In Advance 

[themistoklis]

@Sowmiya

You cant create slicers from measures (calculated fields)