Forum Discussion

cprabhu's avatar
cprabhu
New Member
4 months ago

Dynamically link Hierarchy In Visualization with Hierarchy in Data or Table Pane

Microsoft:

 
Assume you have created a Hierarchy in the Table Panel. It becomes a container now.
 
Now, right-click on the table field (Region) and add it to the Hierarchy. Repeat this step for (State). Now drag the hierarchy into 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 subcategories.
 
Remember:
 
Why am I writing to Microsoft? The Hierarchy in Visualization panel is not linked to the Hierarchy in the table, which is a limitation. I hope the Microsoft Power BI team has yet to fix.
 
So, what is the result of this? Your hierarchy in the Visualization pane will not automatically update if you add another field, City as a subcategory, to this hierarchy. To reflect the updated Hierarchy in the Visualization panel, you need to delete the Hierarchy in the Visualization Panel with Region and State, and drag the updated Hierarchy containing Region, State, and city fields.
Data Protection

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 months ago

    what is your question? Do you consider this a bug, or a feature request?

     

     

  • cprabhu's avatar
    cprabhu
    New Member
    4 months ago

    It is not a bug, it is an feature enhancement with realtime update. This hierarchy applies to custom hierarchy created by the user not numeric hierarchy created by Power BI based on column, such Category "Date", Subcategory "Year, Quarterly, Monthly, Day"

  • v-prasare's avatar
    v-prasare
    Community Support
    4 months ago

    Hi cprabhu , 

    If this is feature request, i’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas.

    Feedback submitted here is often reviewed by the product teams and can lead to meaningful improvement.

     

     

    Thanks,

    Prashanth

  • v-prasare's avatar
    v-prasare
    Community Support
    4 months ago

    We are following up once again regarding your query. Could you please confirm if you have raised ideas with Microsoft?
    If not please raise idea and upvote it. Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.