100% Stacked Column Chart Converted to Line Chart

[RedTangerine]

Currently I have 2 charts column and 100% stacked column.

I need to show these as line charts with trend lines.

The first I can do resonably easy but I cannto figure out how to go about getting the line chart to work as a 100% stacked line chart. Specifically I need to show how many of my incidents are posted status against the monthly total.

[v-huizhn-msft · Accepted solution]

Hi @RedTangerine,

Based on my understanding, I create the following sample table.

sample table
Then I create a 100% sttacked column chart similar with yours, please see the screenshot.

Finally, create a measure using the formula to get the posted status vs total, and transfer the 100% Stacked Column Chart to Line Chart.

posted-percentage = CALCULATE(SUM(Table3[value]),FILTER(Table3,Table3[status]="posted"))/SUM(Table3[value])

If you want to calculate the percentage of unposted, just replace the posted to unposted in the filter of measure.

Create a line chart, select the data as x-axis, the measure as value, you will get expected result.



Best Regards,
Angelia

[RedTangerine]

Thank you.

This was exactly what I needed.

I changed it a little so that Count was used instead of sum and an extra calculate so that I could multiple by 100

but overall the solution was spot on:

posted-percentage = CALCULATE(CALCULATE(COUNT('riskman incident_fact'[Status (groups)]),FILTER('riskman incident_fact','riskman incident_fact'[Status (groups)]="posted"))/COUNT('riskman incident_fact'[Status (groups)])*100)