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
mariner84
Advocate I
Advocate I

Percentage in clustered column

Hello,

 

I have a clustered column showing total requests by date, but I'd now also like to show what percentage of the requests came from a certain criteria.

 

I have a sample pbix here

 

Capture.JPG

 

If anyone is able to help, that would be appreciated.

 

Thank you

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @mariner84 ,

 

I created a measure "Assignment Business Partner" using this DAX:

 

Assignment Business Partner = 
 DIVIDE(
     CALCULATE(
         COUNT('Page 1'[Number])
         , FILTER(ALL('Page 1'[Level 4]) , 'Page 1'[Level 4] = "Business Partner")
     )
     , CALCULATE(
         COUNT('Page 1'[Number])
         , ALL('Page 1'[Level 4])
     )
 ) 

 

adding this measure to the clustered line chart, to the line values

image.png

will result in this chart:

image.png

To achieve the formatting as a percentage value, you can either multiply by 100 by tweaking the measure, or you can use the formatting of the measure.

Hopefully, this is what you're are looking for.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey @mariner84 ,

 

I created a measure "Assignment Business Partner" using this DAX:

 

Assignment Business Partner = 
 DIVIDE(
     CALCULATE(
         COUNT('Page 1'[Number])
         , FILTER(ALL('Page 1'[Level 4]) , 'Page 1'[Level 4] = "Business Partner")
     )
     , CALCULATE(
         COUNT('Page 1'[Number])
         , ALL('Page 1'[Level 4])
     )
 ) 

 

adding this measure to the clustered line chart, to the line values

image.png

will result in this chart:

image.png

To achieve the formatting as a percentage value, you can either multiply by 100 by tweaking the measure, or you can use the formatting of the measure.

Hopefully, this is what you're are looking for.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

@TomMartens this is awesome, exactly what I was looking for. Appreciate your quick response.

 

Thank you,

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.