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.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi imy 

 

Without knowing exactly what measure you are using. I would assume you could click on the measure in the field pane, then click the Modeling tab on the tool bar. Next select percentage under the format drop down list.

 

As far as the bar width goes, MFelix  is right on the money.

 

Hope this helps!

imy's avatar
imy
Helper I
7 years ago

Hi, sorry I should have mentioned this, my only value is the following measure: 

Tickets = COUNTROWS(WHD_Tickets)