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.
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.
Solved! Go to Solution.
Hi @RedTangerine,
Based on my understanding, I create the following 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
Hi @RedTangerine,
Based on my understanding, I create the following 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
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |