Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, i would like to display different columns in bar chart
For example for this table:
Price | Category1 | Category2 |
100 | Shirt | Jeans |
200 | Shirt | Jacket |
300 | Shirt | Shoes |
The bar chart should like then like this:
When i use both colmns in the bar chart, i can only expand to the next level.
Any ideas?
Thanks in advance
Solved! Go to Solution.
select price column and unpivot other columns in pq
then you can get the expcected output
Proud to be a Super User!
select price column and unpivot other columns in pq
then you can get the expcected output
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |