Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to build the following stacked column chart:
Is this possible to do? Thank you
Thank you. Below is an example of a sample data set I threw together - would it be possible to list out all the Clothing Types shown in the legend of the left-hand graph (ie: button up, dress pants, etc.) underneath the respective group they belong to in the right-hand graph? The last screenshot shows what clothing types are within each group.
To be able to achieve what you want, you need to be able to add 2 columns in the legend which is not simething you can do in power bi .
one possible option maybe, to create a concatenated column as :
new column = table_name[clothing_type_groups] & " - " & table_name[clothing_type]
and use it as a legend .
another option is using a custom visual : like this one .
third option would be : adding both columns to the X-axis.
and enable the drilldown option ( circled in red ) ,
this way when you click on a group it automatically goes to the second level .
let me know if these are possible solutions for you.
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍
User | Count |
---|---|
94 | |
78 | |
73 | |
64 | |
60 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |