Toggle multiple fields between raw and cumulative with one button

[jjunck]

I have a plot of multiple counts by date on one axis which I'd like to be able to toggle between the raw data and cumulative plot using a single button or slicer. The dataset columns are essentially:

date

count1

count2

count3

count4

count1_cu

count2_cu

count3_cu

count4_cu

I can easily use a slicer to enable and disable the two sets in 8 clicks, but this is not user-friendly. Is there a way to set this up such that with one click the plot toggles between the raw and cumulative fields?

[Anonymous · Accepted solution]

Hi @jjunck ,

You can use bookmarks in Power BI to toggle between raw and cumulative data with a single click.
Create a visual overlap of the two and use bookmarks to toggle their visibility.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...