Forum Discussion

Shakeerm's avatar
Shakeerm
Helper II
6 years ago
Solved

Percentage Labels into a Line & Stacked Column Chart

Hi  I have a Line & Stacked Column Chart that illustrates the Ontime/Overdue jobs for each Job Branch I need to show the Percentage of 100% for each Branch.    When i tried to Show Value as Perce...
Need Help
  • sanimesa's avatar
    sanimesa
    6 years ago

    Shakeerm  You may need to create a few measures for this. Here is a sample worked out - please create measures like this:

     

     

    Total Count = COUNTROWS(OnTime)
OnTime Count = CALCULATE([Total Count], OnTime[Status]="ONTIME")
Overdue Count = CALCULATE([Total Count], OnTime[Status]="OVERDUE")
% OnTime = DIVIDE(OnTime[OnTime Count], [Total Count])
% Overdue = DIVIDE([Overdue Count], [Total Count])

     

     

    Then set up the chart as shown in the picture below.

sanimesa's avatar
sanimesa
Post Prodigy
6 years ago

Shakeerm  You may need to create a few measures for this. Here is a sample worked out - please create measures like this:

 

 

Total Count = COUNTROWS(OnTime)
OnTime Count = CALCULATE([Total Count], OnTime[Status]="ONTIME")
Overdue Count = CALCULATE([Total Count], OnTime[Status]="OVERDUE")
% OnTime = DIVIDE(OnTime[OnTime Count], [Total Count])
% Overdue = DIVIDE([Overdue Count], [Total Count])

 

 

Then set up the chart as shown in the picture below.