Below is the chart from Tableau. Automatic bar chart with muliple headers . What is the PBI equivalent for this?
Can you please suggest an alternative approach in PowerBI to achieve a similar visualization? I have disabled the concatenate feature, but whenever I change the parameters, the X-axis automatically collapses. I have to manually drill down to the last level every time.
Please provide guidance, that will save my day. thank you.
@jack555 ,You can not get same, You can have similar one
Refer to my two videos on this topic. Two columns on axis-> expand -> Sort on axis columns -> Concatenate label off
Bar/Clustered Bar: https://youtu.be/2P5BBRN853c
Concatenate Label off : https://youtu.be/QgI0vIGIOOk
Thank you. I am ok with this closest solution. However how to sort the each items in the X axis.
In the below visual,
1,2,3 in the x axis is quarter of sales
next row is volume of orders
labels at the top is profit percentage
I would like to sort by city and quarter not by number of orders. quarter should be always in chronological order.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
49 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |