How to change count to percent

[asoroush]

hi

i have a chart as attached below

i want to change the number is shown to percent of green column, red column too( percent of red column than green column)

how can i do that??

any comment is appreciated

[rakeshb]

Please click on the down arrow button on the "Total Time of Delivery" and change it to the percent of the total.

[asoroush]

hi

i have a chart as attached below

i want to change the number is shown to percent of green column, red column too( percent of red column than green column)

how can i do that??

any comment is appreciated

[nickchobotar]

@asoroush

You will have to create separate DAX measure for each value
e.g

TotalDelivery %:=

DIVIDE (

    SUM(Table[TotalDelivery]),

    CALCULATE (

       SUM(Table[TotalDelivery]),

       ALL (Table)

   )
)

[asoroush]

can you explain a bit more please?

step by step please

thanks

[nickchobotar · Accepted solution]

@asoroush

You will need to create 3 DAX measures : Total Delivery , Total On Time Delivery, Total Delay. Here is the pattern for Total Delivery. You just change the fields for the other two measure.

*** Copy / Paste this

TotalDelivery %:=

DIVIDE (

    SUM(Sheet2[TotalDelivery]),

    CALCULATE (

       SUM(Sheet2[TotalDelivery]),

       ALL (Sheet2)

   )
)

Once you have the measures add them to your chart instead of the fields.

N -