Line chart showing values as a % of two comparative points instead of whole chart

[Anonymous]

Hellooo!

I can't share my dataset, but I've made a line chart that shows the past 12 months and the value is split by a legend that shows Red product and Blue products.

I tried to make the values on the line chart a % but it shows it as a % of all the points on the chart (% of grand total). Whereas I want to show the % as Red vs Blue products for each month. Is this possible?

For example,

Red 10%       Red 25%         Red 60%

Blue 90%       Blue 75%       Blue 40%

Jan 20            Feb 20           March 20

I hope this makes sense?

[negi007 · Accepted solution]

@Anonymous  I think there is no direct way of creating Stack line chart in %. I suggest you to do the following

1. Create two measures 

Blue% = CALCULATE(SUM('Line Chart%'[Value]),'Line Chart%'[Color]="Blue")/CALCULATE(SUM('Line Chart%'[Value]),ALLSELECTED('Line Chart%'[Value]))

Red% = CALCULATE(SUM('Line Chart%'[Value]),'Line Chart%'[Color]="Red")/CALCULATE(SUM('Line Chart%'[Value]),ALLSELECTED('Line Chart%'[Value]))

2. Then you plot your measures on the chart as show below

 

I hope this solution helps you

[Anonymous]

@negi007 Thank you that worked!!

[Fowmy]

@Anonymous 

You can add this measure, adjust the names as per your model

Measure 2 = 

VAR _TOTAL = 
    CALCULATE(
        SUM(Table5[Value]),
       ALLSELECTED(Table5[CATEFORY])
    )

RETURN
DIVIDE(
    SUM(Table5[Value]),
    _TOTAL
)

You can also use 100% stacked Column Visual.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

@Anonymous , something like this

divide(calculate([measure]), calculate([measure],allexcept(Table,Table[Month-year])))