Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a columns of data that looks like this:
In my bar chart I want it to show the averages by these categories by Year, but the bar chart doesn't seem to be able to switch on row/column like excel does:
I want it to be able to show like this instead:
Any ideas?
Solved! Go to Solution.
You need to select Unpivot Columns in Query Editor first, then drag Attribute to Axis.
Switch your Axis with your Legend.
How do I do that?
I cant place more than 1 data field in the legend, so which data field should i pull to the legend? i'm puzzled, would be great if you can guide me through.
@smoupre wrote:Switch your Axis with your Legend.
Hi, when i pulled the "Year" to the legend, I can only add only 1 datafield into the bar chart..why?
You need to select Unpivot Columns in Query Editor first, then drag Attribute to Axis.
Thanks I figure that out eventually! 🙂
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |