Toogle MTD and QTD

[joshua1990]

Hello everybody!

I need a toggle button to switch between MTD and QTD Sales on one view.

In my calendar table, I have a TRUE/FALSE column for MTD and QTD.

How would you build a button to switch between MTD and QTD?

Would you use a button and a bookmark? Or is there a more elegant way like a filter?

[V-pazhen-msft · Accepted solution]

@joshua1990 
Lets if you have MTD and QTD measure, you can create a slicer to display the selected one on the visual. You can take look my reply and the sample pbix in this post
https://community.powerbi.com/t5/Desktop/Need-to-display-only-selected-ones-in-the-chart/m-p/1149907

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@joshua1990 , Refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Making slicer button

https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive

[mahoneypat]

You could do this with Buttons and Bookmarks, but also consider this approach with a disconnected table described in this article

https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

Once you make the slicer (oriented horizontal), it will looks like MTD and QTD toggle buttons.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat