Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Row header from slicer selection

Hello all, Iam Trying to perform Dynamic nature in matrix. Selected columns in slicers will add to matrix. Iam doing this by unpivoting the columns in data. so when i bring the values into matrix ro...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

Based on my research, it is not supported in Power BI now.

There're some similiar ideas which you can vote them up: 

Dynamic Column Names in a table,

Dynamic measure name.

 

One workaround: you can create a measure and create a card visual like so:

Measure =
IF (
    HASONEVALUE ( 'Table'[Attribute] ),
    VALUES ( 'Table'[Attribute] ),
    "Attribute"
)

 

Best Regards,

Icey

 

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

 

rachelbabcock's avatar
rachelbabcock
Helper I
5 years ago

Hi! I hope the creator of the solution above ^^ sees this or, if not, perhaps someone else could help.

 

How do you now go back and relate that new table to your original table to get the right sales value? It shouldn't be 82,900 every time. I'm trying to do something similar but cannot get that relationship to work.