Forum Discussion
Dynamic Column values based on Slicer Selection
Looking for a solution for the below given problem:- I have a around 12 columns in a dataset which are plotted in a line chart. Out of this 8 are P1 and 4 are P2 category. I need to slice the...
Anonymous
You may aslo try Unpivot Columns in Query Editor, then take advantage of the Legend field.
Hello @v-pussah ,
I think you can use the bookmark function to do it.
Create two tables, one for P1, one for P2, and create two markers for these two tables.
Next, create a column with two values, such as: P1 and P2.
Click P1 for bookmarks, P2 for markers, and for the button, you can use force selection.
Please try.
Aiolos Zhao