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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BobPierre
Frequent Visitor

STACKED CHART

Good day good people.

I am new to Power BI. I have a set of data that I want to display like this: To display Percentage of column total.

 

The excel is the way the data loaded into Power Bi looks like.

 

Thank you all in advance.

D.png

 

 

4 REPLIES 4
v-danhe-msft
Employee
Employee

Hi @BobPierre,

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

1.I have entered some sample data like the picture below:

L.PNG

2.Create a measure.

MeasureA = (CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Compliance Rate]=MAX('Table1'[Compliance Rate])&&'Table1'[Transpoter]=MAX('Table1'[Transpoter]))))/CALCULATE(SUM(Table1[Value]),FILTER(ALL('Table1'),'Table1'[Transpoter]=MAX('Table1'[Transpoter])))

3.Create a Stacked column chart and add the related field. Now you can see the correct result.

LL.PNG

 

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

https://www.dropbox.com/s/ew4wb604joyxzeb/STACKED%20CHART.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.

Thanks for your response.

But my data does not have value, so, I am a bit confused.

 

Hi @BobPierre,

To find the cause as soon as possible, I would suggest you share pbix file if possible. If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

 

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.

Thank you, Daniel.

 

The Data is as below:

Compliance Rate  TRANSPORTER

Non ComplianceEGYPT
Non ComplianceEGYPT
Non ComplianceNIGERIA
Non ComplianceEGYPT
Non ComplianceNIGERIA
Non ComplianceEGYPT
ComplianceEGYPT
ComplianceEGYPT
ComplianceEGYPT
ComplianceEGYPT
Non ComplianceEGYPT
Non ComplianceEGYPT
ComplianceEGYPT
ComplianceEGYPT
Non ComplianceEGYPT
ComplianceBENIN
ComplianceTOGO
ComplianceEGYPT
ComplianceTOGO
Non ComplianceEGYPT
Non ComplianceTOGO
ComplianceNIGERIA
ComplianceBENIN
ComplianceTOGO
ComplianceTOGO
ComplianceNIGERIA
Non ComplianceNIGERIA
ComplianceBENIN
ComplianceBENIN
ComplianceNIGERIA
ComplianceTOGO
ComplianceNIGERIA
Non ComplianceBENIN
ComplianceBENIN
ComplianceBENIN
Non ComplianceBENIN
Non ComplianceBENIN
ComplianceBENIN
ComplianceBENIN
ComplianceBENIN
ComplianceBENIN
Non ComplianceBENIN
Non ComplianceBENIN
Non ComplianceBENIN
ComplianceNIGERIA
Non ComplianceNIGERIA
Non ComplianceTOGO
ComplianceNIGERIA
ComplianceTOGO
Non ComplianceTOGO
Non ComplianceNIGERIA
Non ComplianceNIGERIA
Non ComplianceNIGERIA
ComplianceNIGERIA
Non ComplianceTOGO
Non ComplianceTOGO
Non ComplianceNIGERIA
Non ComplianceNIGERIA
ComplianceTOGO
ComplianceTOGO
Non ComplianceNIGERIA
Non ComplianceTOGO
Non ComplianceTOGO
Non ComplianceTOGO
Non ComplianceTOGO

 

 

 

Looking forward to hearing from you soon.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.