Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Avivek
Post Partisan
Post Partisan

The data to appear as stacked column chart

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
Capture.PNG
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
 
 

Capture1.PNG

 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.

2 ACCEPTED SOLUTIONS
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

amitchandak
Super User
Super User
5 REPLIES 5
amitchandak
Super User
Super User

@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

Avivek_0-1599558660202.png

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
 
 
 

Capture3.PNG

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.

 

@Pragati11 @amitchandak ,

 

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

Hi @Avivek ,

 

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

Or may share your sample data?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.