Forum Discussion

ClackamasAshley's avatar
ClackamasAshley
Frequent Visitor
2 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

ClackamasAshley's avatar
ClackamasAshley
Frequent Visitor
2 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Your 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.