Forum Discussion

chris9486's avatar
chris9486
New Member
3 years ago

Showing Ratios in a Pie or Graph

First post so please forgive me any nuances.

 

I am new to Power BI - got a new job and they asked me to learn. Been watching YouTube tutorials for 2 weeks solid now. I am starting to build a weekly report, currently done manually from several excel docs which is then putting it into a PowerPoint, it's labour intensive. Since the data layout never changes, just the numbers, I think a dashboard is the way forward.

 

I am struggling with displaying ratios. I have made a table (visualisations) and have a ratio calculation column in this, I was quite proud of myself for working that dax out. But I want to make this more visual. I want it to be in a graph or pie chart. But I can only ever get it to display in percentage terms. I want it to show 1:11 or 1:5 or 1:8. This is what my table looks like

 

Filter on: by manager pay grade

 

AreaManagersStaffRatio
North30.86329.101:11
East31.59213.181:7
South14.92117.951:8

 

Is there a way to display the above in a pie or graph?

Need Help
Tips and Tricks

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    What's your business statement?  11 staff per manager in the North, and 7 staff per manager in the East?  For that a column chart would be more appropriate.

     

    You can add your ratio column as a tooltip but it doesn't really add value.

     

     

    • chris9486's avatar
      chris9486
      New Member
      3 years ago

      It's a request to show the ratio of staff to managers in the regions. They wanted it in a graphical form rather than just a table, but to show the ratios also. 

       

      I just couldn't think of how to display it but I think the bar charts will work. Thank you.