Forum Discussion
Dynamically legend
Hello everyone, We build a schema for analysis any measures in the same sheet Measure =
VAR Logic Test =
COUNTROWS(DISTINCT(FILTER(ALLSELECTED('KPI´s'[KPI]),'KPI´s'[KPI] = "Real Sales"))) = 1...
Anonymous
Follow below steps to get dynamic legends:-
1) Open the data table in Power query adn DUPLICATE it and rename the other table.
2)Remove the unwanted columns from table.
3)Add index to both tables(Original Table and Duplicate table).
4)Select and unpivot the columns that you want to display dynamically as legend.
5)After unpivoting you will get two new columns having ATTRIBUTE and VALUE
6) Save and close power query.
7)In Model view tab, create relationship between Original Table and New unpivot table on Index column.
😎 Now you can put the ATTRIBUTE column from new table(on which we have done unpivoting) in column series of clustered chart.
Do we have any solution to this requirement?