Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I create a stacked bar chart where the total assets (i.e. 10) represnets the full bar, and then broken down by the subcategories of the assets( i.e. 4 and 6).
When I do this, the resulting total is not accurate, it's as if Power Bi is adding 4+6+10, and not 4 and 6 is part of the 10.
Any help with this please?
@Anonymous , I think you need clustered stacked bar for that
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview
@Anonymous,
Another option would be to use the Line and Stacked Column chart.
Your sub-categories are your column values and your [Total Assets] would be the line value. You can set Line Width to 0 to show only the Markers representing the Total Assets.
Regards,