Forum Discussion
Toggle multiple fields between raw and cumulative with one button
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?
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 TeamIf 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
2 Replies
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-Forum/ba-p/963216
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/1447523Hi 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 TeamIf 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
