cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DNA Frequent Visitor
Frequent Visitor

Line Chart With Values As a %

 

What I'm trying to do is a line chart that's basically the same as a 100% Stacked Column Chart, but displays in a line graph format

 

X Axis: Month Aggregates (Mar, April, May)

Y Axis: Percentages (0 - 100%)

Legend: Consists of 5 categories (Conforming, FHA, Non-Conforming, USDA, VA)

 

The line graph will initiallly plot the count of these values for each month in these different catgegories.  There is an option to show the value as a percent of the grand total. However, i don't want the percent of the grand total. The grand total takes March values, and divides by the total of March, April, and May.  

 

I would want the percent breakdown for each category just within a given month.  So I want a % breakdown for Mar, one for April, and one for May and plot accordingly on the line graph.  This is easily done with a 100% Stacked Column Chart as well as a Matrix.  However,  I can't get this to work for a Line Chart

 

Example:

Month: March

Conforming: 100 

FHA: 50

NonConforming: 25

USDA: 10

VA: 5

 

Total:  190

 

So the % breakdown for the month of March is the following:

Conforming: 53%

FHA: 26%

NonConforming: 13%

USDA: 5%

VA: 3%

 

I don't want to take Conforming values for March (100) and divide them by the grand total of March, April and May.

 

Does this make sense any thoughts to work around this for a line chart?

 Line Graph_Percent of TIme Aggregate.jpg

 

 

 

 

 

7 REPLIES 7
mdannemiller Frequent Visitor
Frequent Visitor

Re: Line Chart With Values As a %

Could you create a column which calculates the percentage for the month, and then use a stacked line chart?  If every month equals 100% it should look like a 100% stacked column chart.

airaqi Frequent Visitor
Frequent Visitor

Re: Line Chart With Values As a %

Hi @DNA

I am facing the same issue, did you find a solution?

thanks

airaqi Frequent Visitor
Frequent Visitor

Re: Line Chart With Values As a %

Hi,

someone else who can help?

anandprakashnm Frequent Visitor
Frequent Visitor

Re: Line Chart With Values As a %

same issue with me

shkabuzar Frequent Visitor
Frequent Visitor

Re: Line Chart With Values As a %

Same issue with my report,  please some one provide solution for this

 

Highlighted
shkabuzar Frequent Visitor
Frequent Visitor

Re: Line Chart With Values As a %

Hi,

Please try this.

Measure =
DIVIDE (
    SUM ( Table1[Count] ),
    CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) )
)
MariaRosa New Member
New Member

Re: Line Chart With Values As a %

@shkabuzar thanks, your help is the solution. I can show my graphic i want.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,654)