Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I suspect the answer is 'its not possible' to this question, but I am hoping there is a trick I'm missing
I have a data set where each row represents an individual - the first group of columns are characteristics about that individual, there is then a group of columns with different measures in.
I have set a report up which shows the measures split by the characteristics of the inidividual.
In the example shown for instance the charts use KS2_ELIGRWM as the value and KS2_RWMEXP as the legend / detail - the various characteristic columns are used for the axis.
The only way I can see to create the same set of charts for the other 2 measures shown (KS2_ELIGREADLA and KS2_ELIGMATLA) would be to duplicate the pages and change the measures manually - however, ideally I would like to be able to put a selector in so that they can be selected on the same page - is there a way of doing this?
Solved! Go to Solution.
You may select Unpivot Columns in the Query Editor first.
You may select Unpivot Columns in the Query Editor first.
Fantastic - worked a treat - thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |