Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
2 years ago

Use Slicer Value as Column Header in Matrix

Hi,

I unpivoted my data so now I have Hierarchy Parent in Attribute and the Child Members in Values
Looks good in Matrix except the Header is Value.

How can I update the Header based on the selected Attribute in the Slicer?

Thanks,
-w

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    tecumseh , if you need a Hierarchy of measures, then consider calculation groups with custom columns

     

    refer

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

     

    The calculation can not be used from Power BI desktop

     

    calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi tecumseh 

     

    Regarding the “Matrix Header is Value” you mentioned, does it look like the part marked in the picture below. If so, there is no way for it to be dynamically updated in Power BI Desktop due to it is determined by the fields that are put into the Matrix Visual Rows. If you put “Attribute” into Matrix Visual Rows, then the header would be “Attribute”.

     

    Please correct me if I understand your description incorrectly. And, It would be great if you could provide screenshots of your matrix visual and dummy data.

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

    • tecumseh's avatar
      tecumseh
      Resolver III
      2 years ago

      Thanks Anonymous 

      You got it.
      Maybe need a different approach than unpivot data.

      1. Create disconnected table slicer of 4 hierarchy parent names
      2. Create summarized calc table based on on the selected slicer.  Calc table to include 
      a. All children of selected parent
      b. Date
      c. Channel
      d. Measure_1
      e. Measure_2
      f. Measure_3

      Thanks,

      -w