cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrejBI
Helper V
Helper V

Create a decomposition tree using an Index Column?

Hi, I am looking for a way to create a decomposition-tree visual using this index column: 

AndrejBI_0-1614691430794.png

The index shows "steps"/event triggers for each session

 

I know the visual only allows columns as different steps, so I tried pivoting the 'Final Index' column: 

AndrejBI_3-1614691114349.jpeg

Apparently, the index is not the only thing that differs for each row, hence I got this result after pivoting the column. Also, it's not that convenient to have 35 new columns after pivoting the index column 

 

Optionally: is there any other visual which can do this? 

1 REPLY 1
v-luwang-msft
Community Support
Community Support

Hi @AndrejBI 

could pls provide your pbix file ? Remember to remove the confidential information.

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.