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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ledemon
Frequent Visitor

Percentage of column total in Line chart

hello everyone

I am trying to make a chart with the percentage of the merchandise that was delivered on time, late or early for each period in a line chart.Annotation 2020-02-21 222326.pngAnnotation 2020-02-21 22212326.png

but for some reason the chart is giving me the percentage of grand total I believe,  

what I want is to replicate the data that is shown in the Matrix below

does somebody know how I can do this?   I appreciate your help 

 

 
4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Share the link from where i can download your PBI file.  Show your expected result very clearly.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Sorry if I was ambiguous

what I want in the chart is to show the total percentage of each report period, not the percentage of grand total, below you can see how the table looks like right now, 

 

Annotation 2020-02-21 22212326.png

Hi,

I still do not understand.  For now, please do not focus on the visualisation.  Just share data in a Table format and show the expected result in another column of that table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

If it was a/b then you should tell it is % . But if it is 1/b*100, then you should show absolute value. Can you check you are showing as absolute or percent

 

Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.