Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, I'm trying to replicate this stacked column chart in Power BI Desktop. Is this possible?
Thanks.
Solved! Go to Solution.
Sure it is:
If you prefer to restrict the use of the drill/expand options to users, you can turn them off in the formatting pane (even though you will still see the icons in Desktop, they will not be visible once you uoload the report to the service).
Proud to be a Super User!
Paul on Linkedin.
Yes, I've tried the stacked 100% column chart. However, the chart only displays the school information. It doesn't show the year (i.e. 2019, 2020, 2021) in the image above.
You need to add the Year field to the x-axis and drill down to the lowest level. If you select the visual, you will see an icon with a line branching into 2 arrows on the top right of the visual. Select it.
Proud to be a Super User!
Paul on Linkedin.
thanks.. yes, I tried that but I would prefer it to be shown upfront as per the image above.. am I right to say that it is not achievable in Power BI?
Sure it is:
If you prefer to restrict the use of the drill/expand options to users, you can turn them off in the formatting pane (even though you will still see the icons in Desktop, they will not be visible once you uoload the report to the service).
Proud to be a Super User!
Paul on Linkedin.
use 100% stacked column chart in power Bi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |