Forum Discussion
Helper IVCreate stacked bar chart from clustered column
I have a clustered column chart that looks like this. For the axis I use this expression -
I want to make the fourth bar split between backorders and the q2 actuals, so I want four bars but to create the fourth I wanted to stack the 3rd and 4th bars. Is this possible?
3 Replies
- TomMartens
Super User
Hey poweruser55 ,
please take the time and create a pbix file that contains some sample data, but still reflects your data model (tables, relationships, calculated columns, and measures.) Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method share the xlsx as well. Describe the expected result based on the sample data you provide.
Please create a simple scribble of the clustered column chart you want to create, based on the sample data you provide.
Regards,
Tom
poweruser55I changed it so now th values are pulling the actuals numbers from the excel file and the axis is scenario. Now what I want to do it stack the fy22 q2 act bar and march ooo bar.
- poweruser55
This is the formula I am using for March OOO what I want is to split the first and second calulcate function in the stacked bar graph so it has 2 colors, one for stockout/backorder and one for q2 actuals. TomMartens
