Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 3 columns of time ,budget and quality and all these 3 columns have 3 distinct values i.e. red, green and amber. I want to create horizontal bar chart
Like this and my table looks like this:
So the bar graph should tell the count of green,amber, red of Time in a single bar and same for budget and quality.
How do I make this transformation ?
Solved! Go to Solution.
you can do the data transform in pq.
pls see the attachment below
Proud to be a Super User!
i think you can try unpivot columns
Unpivot columns (Power Query) (microsoft.com)
could you pls provide the sample data?
Proud to be a Super User!
you can do the data transform in pq.
pls see the attachment below
Proud to be a Super User!
you are welcome
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |