Forum Discussion
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 rows, row header is value only. i want to change this dynamically based on slicer selection.
Please notice that if i want to bring 4 columns as dynamic to matirx, i will have four slicers as attributes for selection.
So, let me know how can i perform dynamic row header. Placing the card and all doesnt work.
Thankyou.
3 Replies
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,
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.
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.
Hi Anonymous ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards
Icey
