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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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