Forum Discussion
Change decomposition tree root with slicer or button
Hi everyone,
I have a decomposition tree visual where I analyze the unit cost by brand name and class name and I would like to give the users the ability to choose between unit cost and unit price (with a slicer or a button).
I thought about using bookmarks but the issue is that the state of the visual is not the same when I move from a bookmark to another. For example first I am with this configuration :
But when I move to the other bookmark the tree is not developed as the previous decomposition tree, I get this visual :
Is there a way to change only the root and let the visual in the same state ?
Thank you for your help
Anonymous,
Through this forum, I found a new technique that I have started to use. Create a Measure with a SWITCH statement depending on your Slicer selection.
1) Create a table with your two options: Unit Cost and Unit Price
2) Creat a Slicer with this table
3) Create a Measure to read your Slicer selection: SelectedOption = SelectedValue( Options[Value] )
4) Create a new Measure something like:
VisualMeaure = Switch( [SelectedOption] = "Unit Price", [Unit Price], [SelectedOption] = "Unit Cost", [Unit Cost] )Not sure if this syntax is correct, but hope you get the idea.
I have not used the Decomposition Visual, but hope this idea works for you.
Regards,
2 Replies
Anonymous,
Through this forum, I found a new technique that I have started to use. Create a Measure with a SWITCH statement depending on your Slicer selection.
1) Create a table with your two options: Unit Cost and Unit Price
2) Creat a Slicer with this table
3) Create a Measure to read your Slicer selection: SelectedOption = SelectedValue( Options[Value] )
4) Create a new Measure something like:
VisualMeaure = Switch( [SelectedOption] = "Unit Price", [Unit Price], [SelectedOption] = "Unit Cost", [Unit Cost] )Not sure if this syntax is correct, but hope you get the idea.
I have not used the Decomposition Visual, but hope this idea works for you.
Regards,