Percentage in clustered column

[mariner84]

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

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

Thank you

[TomMartens · Accepted solution]

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

will result in this chart:

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

[mariner84]

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

Thank you,