Use Slicer Value as Column Header in Matrix

[tecumseh]

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

[Anonymous]

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]

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

[amitchandak]

@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