Column chart-- Option to combine or separate column series

[yf569]

I have a column chart and column series. Suppose my column series has value a,b,c. Do I have the option to let users select to show the sum value of a,b,c, or to show seperate value of a,b,c ?

Thanks for your help! 

[v-eachen-msft · Accepted solution]

Hi @yf569 ,

You can use bookmark to meet this requirement. You can refer to this document of bookmark:https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Firstly, you need to choose the following options to open bookmarks pane and selection pane.

Then create two visuals: one to display separate columns and another to display sum value. At the same time, you need to create two bookmark buttons renamed “sum” and “separate”.

Now in the selection pane, you can select which visual can appear. Add a bookmark in the bookmark pane when you are ready to save the report states.

At last, you need to define the direction of two bookmarks.

You can press ctrl + click to choose bookmark.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yf569]

Hi Eads,

Thanks for your reply. What do you mean by define the direction of the bookmarks? 

I created two bookmarks the clicked 'View'. The book mark appears on the botton of my report and I can switch between different bookmarks. But is there a way to have something like a switch button on individual visuals? Because my report is consists of several visuals, not just one column chart.

Thanks!

[v-eachen-msft]

Hi @yf569 ,

The direction means the setting in the following image.

And you need to use ctrl + click to use bookmark. As for your other visuals, you can set them "show" or "hide" in Selection pane. You can find more details in the preview answer's link.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.