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.

     

MFelix's avatar
MFelix
Super User
7 years ago

Hi imy ,

 

What is the percentage you want to make? can you share how your measure is calculated?

 

Regarding the size of the bar if you go to the Y-axis options you can play around with the inner padding and the category width.

 

Regards,

MFelix

  • imy's avatar
    imy
    Helper I
    7 years ago

    Hi my only measure in this 

    Tickets = COUNTROWS(WHD_Tickets)
     
    I would like to have the number of tickets and the % to the grand total.
     
    many thanks!
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      drag that measure to both the value slot and the tooltip slot.  Select the drop down arrow on the side of the measure in the tool tip slot and click show value as>% grand total.