2 of 2 people found this helpful
So currently you have data something like this:
empno , fixed , variable
1 100 50
2 200 30
You need to pivit your data as below
emp no salary salary_type
1 100 fixed
1 50 variable
2 200 fixed
2 30 variable
You can do this in data source pane by selecting 2 measures , right click and choose pivot.
Now you just need to put emp no on row shelf, salary on column shelf and drag salary type to color to get stacked bar chart.
Hope it helps.
Thank you Ankit, works great!