cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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 Percent of grand total it shows the Branch Percentage for all the Branches.

This is the Column that i have added to formulate Ontime/Overdue

Tried a few DAX functions and none of them gave a the right results.

Appreciate the Help

1 ACCEPTED SOLUTION
Post Prodigy

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

3 REPLIES 3
Community Support

Just create a measure as below:

``````Measure =
DIVIDE (
CALCULATE ( COUNTA ( 'HR Performance Analysis Report'[Job No] ) ),
CALCULATE (
COUNTA ( 'HR Performance Analysis Report'[Job No] ),
ALLSELECTED ( 'HR Performance Analysis Report'[Overdue] )
)
)``````

Then drag this measure into Column values of the visual.

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Prodigy

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

Anonymous
Not applicable

Try this measure:

``Pencentage Values = COUNTA(Table[Overdue]) / CALCULATE(COUNTA(Table[Overdue]),ALL(Table[Overdue]))``

Change the data type to pecentages and you should be good to go. It's going to mess with your axis though.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors