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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
akshah
Frequent Visitor

Stacked Column Chart individual 100%

Hello Guys i have a doubt,

 

I want to create a stack column where each axis is made up of 100% like thisCapture.PNG

 

 

 

But i am not able to do in power bi i am able to do like this Capture1.PNG

 

 

How to go about it?

 

1 ACCEPTED SOLUTION
v-danhe-msft
Employee
Employee

Hi @akshah,

Based on my test, you can refer to below steps:

1.I have entered some sample data to test for your problem in below picture.

1.PNG

2.Create a Clustered column chart and add the [Status], [Value] and [Group] fields and now you can see the result (If the chart values are calculated from a measure, you can drag the measure to Value bucket.).

2.PNG

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/j23azxfgdoz7ss2/Stacked%20Column%20Chart%20individual%20100%25.pbix?dl=0

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-danhe-msft
Employee
Employee

Hi @akshah,

Based on my test, you can refer to below steps:

1.I have entered some sample data to test for your problem in below picture.

1.PNG

2.Create a Clustered column chart and add the [Status], [Value] and [Group] fields and now you can see the result (If the chart values are calculated from a measure, you can drag the measure to Value bucket.).

2.PNG

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/j23azxfgdoz7ss2/Stacked%20Column%20Chart%20individual%20100%25.pbix?dl=0

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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