100% stacked column chart in lumira designer 2.4

[hari_ravada]

Hi Team,

I need to display two % measure values into 100% stacked bar chart. The measures are %food sale and %Non-food sales. There is no dimension on x-axis. I want to display the above two measures in a single bar (say 60% food sales and 40% Non-food sale) with two different colors.

When I tried to display them in the chart and configure them 100% stacked, I am getting still 2 bars instead of 1 bar.

I want to display both the measures in a single bar with 2 different colors without using the dimension on x-axis.Is there a solution for it? I am using lumira designer 2.4 and data source is BEX query.

Thanks,

Hari