Forum Discussion
Can we analyse by multiple measures in Decomposition Tree.
We are trying to create a Decomposition tree visual where multiple “measures” and multiple “dimensions” are currently available for analysis.However, as per the business user’s requirements, while it is necessary to start with one “measure”, there is a need to switch to another “measure” dynamically during the analysis.
For example, we have “Sales Amount” and “Product Volume Qty” as measures. While the business user wants to start with “Sales Amount” as a measure, drill down to a “Region”, he then wants to focus on “Product Volume Qty” measure to find how high or low are the product volumes in that specific “Region”.
Is there way to perform this kind dynamic analysis, and how ? It is possible to add “measures” along with “dimensions” for the drill down tree?
2 Replies
- amitchandak
Super User
Anonymous , I doubt so. Please refer latest feature of that at
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Decomp_tree
Hiya. Super late, but thought I'd pop in an answer in case anyone is looking at this in the future.
I've found that creating a parameter with all the measures I want to analyse and then using that parameter as part of a (single select!) slicer works really well with the decomposition tree.
