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

Re: Power BI: Link Visualization Hierarchy with the hierarchy In Table Panel.

Microsoft:
 
Assume you have created a Hierarchy in Table Panel. It becomes a container now.
 
Now Right-click on table  field (Region) , and add to the Hierarchy. Repeat this step for (State). Now drag the Hierarchy in to the canvas
 
-or- 
 
Click on the check-box before the Hierarchy name
 
When you perform one of these, the visualization panel shows the Hierarchy with Region and state as subcategory.
 
Remember:
 
Why am I writing to Microsoft is that the Hierarchy in Visualization panel is not linked to the Hierarchy in the table, which is the limitation. I hope Microsoft PowerPoint BI team would have fixed.
 
So, what is the result of this, your Hierarchy in the Visualization pane will not automatically update, if add another field in, City as subcategory to this  hierarchy, So to reflect the updated Hierarchy in the Visualization panel, delete the Hierarchy with Region, and State, and drag the updated Hierarchy containing Region, State, and city fields.
 
Prabhu
 
Status: New