Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to Hide rows in Matrix Chart using Parent Child Hierarchy

Hi Experts, I have read and tried many different ways to implement below, but just can't get it right. I may very well be missing something obvious   Desired Result: in Matrix Chart, for rows, only...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous , thank you so much for helping. 

I do have a sample file in my local laptop folder, but not able to attach. I have replied the email from Power BI Community Administrator <[email protected]> and attached the file. if this email address does not work for you, is there any other email which I can use ?

Please let me know if you have any question on this sample file.

 

I did use an unconnected table as the source of the slicer (Table: Entity Name List). 

As shown in mine post, the challenge is to how to hide the level1 and level2' s name in the row header ( the measure for level1 and level2 are blank, this is fine).

 

Again, Appreciated your help. 

lillianliyi

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

    You can upload a sample file to the network driver and share the link here or try to export these data to an excel sheet and paste the dummy table records here in table format.

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      HI Anonymous,

      I test on your sample file and find I can't directly hide the parent level when you work with hierarchy fields. (these levels are interactive and the child level will also be removed if you hide the parent level)
      Perhaps you can try to change your field structure like the following blog then you can use a filter to hide the corresponding level records.

      Dynamic Attributes In A Power BI Report - P3 Adaptive

      Regards,

      Xiaoxin Sheng