The data to appear as stacked column chart

[Avivek]

I have to create a stacked colum chart. I have a calculated colum for used/shared,

Used/Shared = IF('DO Vs Tag'[Order Owner ID]='DO Vs Tag'[Tag Owner ID],"Used", "Shared")

Now I have to create a chart as shown below

On the bar i want to see both the used and shared values. But when I try to create a chart like that it appears as below

 I also created different measures for used and shared and still i am getting 2 different graphs. Is it possible to get it as the 1st image.

[Pragati11 · Accepted solution]

Hi @Avivek ,

Try using a 100% Stacked Column Chart in Power BI.

https://www.tutorialgateway.org/create-100-stacked-bar-chart-in-power-bi/

Thanks,

Pragati

[amitchandak · Accepted solution]

@Avivek , seem like you are using clustered column visual use stacked visual or 100 % stacked visual

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

https://www.tutorialgateway.org/create-100-stacked-bar-chart-in-power-bi/

[Avivek]

@Pragati11  @amitchandak ,

I tried using the same stacked charts;

If I add the calculated column- used/shared in the legend and tag id in the values but still it appears as 2 different columns

So I tried using 2 different measures-

Used = calculate(count('DO Vs Tag'[Tag ID]), 'DO Vs Tag'[Used/Shared]="Used")

Shared = calculate(count('DO Vs Tag'[Tag ID]), 'DO Vs Tag'[Used/Shared]="Shared")

But still the chart appears the same

Also I tried the 100%stacked column chart but it still shows the same issue.

Is there any other way to get the result as single bar having both used and shared.

[Avivek]

@Pragati11 @amitchandak ,

It seemed a glitch at that moment. I re did the whole chart again and its working now. Thanyou for the help.

[Pragati11]

Hi @Avivek ,

Can you share your .pbix file please by removing any sensitive information?

Or may share your sample data?

Thanks,

Pragati

[Pragati11 · Accepted solution]

Hi @Avivek ,

Try using a 100% Stacked Column Chart in Power BI.

https://www.tutorialgateway.org/create-100-stacked-bar-chart-in-power-bi/

Thanks,

Pragati