Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
dunn1373
Frequent Visitor

Decomposition Tree - Multiple Analyze Options

Hey all!  I LOVE using the decomposition tree for answering questions for our sales staff when they want to understand breakdowns of accounts.  But I'd like to publish a version that they can use to help serve their respective clients.  I want to have one version/page that has multiple 'Analyze' values.  

 

For instance, I might have a decomposition tree that is a COUNT of all the users in our system.  Let's call them Participants.  I can then decomp them into Gender.  100 Total breaks into 50 Female and 50 Male (as an example).  

 

But what if I want to change the COUNT of all users to a Measure I have created, like the rate at which they start a class.  Only solution I see is to create 2 Decomposition Trees with two different Analyze options.  I was hoping there was a way I could publish something with 1 view that the user could then select the Measure/Value they want to see stratified.  I can't give each of them Pro licenses and they wouldn't know what to do with PowerBI Desktop so it has to be simple.  

 

I hope that makes sense and look forward to feedback!

2 REPLIES 2
Kennethvcesi
Regular Visitor

Create a field parameter along with the measures or calculated columns that you want to switch between. Include among them your primary measure you used for your first decomposition tree. After creating the parameter, use a slicer visual so you can toggle between the options. Drag the newly created field parameter to your decomposition tree as your Analyse or Analysis field. 

lbendlin
Super User
Super User

Enable the "Personalize Visuals" feature in your report. Much more powerful and impactful (plus you get the decomposition tree for free)

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.