Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
asoroush
New Member

How to change count to percent

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

9j1w_121212

1 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 -

View solution in original post

5 REPLIES 5
rakeshb
Frequent Visitor

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

asoroush
New Member

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

@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)

   )
)

 

image.png

can you explain a bit more please?

step by step please

thanks

@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 -

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.