Forum Discussion

imy's avatar
imy
Helper I
7 years ago
Solved

Percentages

Hello, I wonder if you can help me:  I am trying to create a bar chart with percentages. The only value in my data is a New Measure I created that counts the rows on the table. This works well for e...
Need Help
  • kcantor's avatar
    kcantor
    7 years ago

     

    imy 

    Instead of relying on quick measures, build the measure you want. You have:

    Tickets = COUNTROWS(WHD_Tickets)

    Build one to show % Grand Total:

    %Grand Total =

         VAR AllWhdTickets = CALCULATE([Tickets], ALL(Table[Status]))

    Return

    DIVIDE([Tickets], AllWhdTickets)

    Please keep in mind that I do not know what your table is named or the column for your descriptions, you will need to put the correct data into the variable.

     

imy's avatar
imy
Helper I
7 years ago

Hi,

I just realise my x-axis its also in percentages. Ideally, I would like to have them in numbers and the bars in percentages. Its this possible?

This is the end result

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Off of the top my head, the quickest thing you could do is drag the % of grand total measure to the tool tip section, then drag the original measure from the fields pane to the value section. It will give you an outcome similar to this: