Forum Discussion
ClackamasAshley
2 years agoFrequent Visitor
Need to Display Row % Breakdown for One Value in a Chart, Can Only Show This in a Matrix Visual
Hello, I have police call data and have used the actual response times to dispatched calls to create a column that assigns each call as either being responded to </= 5 minutes, or > 5minutes. We have...
ClackamasAshley
2 years agoFrequent Visitor
Here is a set of sample data that only has the fields needed for this visual: https://docs.google.com/spreadsheets/d/17iJEqM3-kxuhH6IcJJW3iKsJwZBoVjtk/edit?usp=sharing&ouid=109601330790345098112&rtpof=true&sd=true
I also built some tables and charts in the spreadsheet to demonstrate exactly what I would like the end result to look like in Power BI. Here is a screenshot of my goal chart:
Anything you could provide to get me in thwe right direction would be greatly appreciated.
Ashley
lbendlin
Super User
2 years agoYour goal chart is not the right type. A 100% stacked column chart requires 100% of the data. You can't just cap that at 30%.
see attached for an alternative proposal.