Clustered columns as percentages

[steambucky]

Hi 

I am using clusted columns but I want to view it as percentages. I did look at the others posts abaout but didnt find anything that worked with my issue. I know help for this will be limted as I can't share the PBIX. 

In the clustered bar chart view my data looks like this: 

This is a graph of how many days it takes to resolve our jobs. I have been asked to view it has percentages BUT still in a clustered bar chart. 

The 100% stacked chart CAN display it as percentages. ( but sigh, thats NOT what they want...) 

Can somone give some advice or point me to a VERY SIMPLE example of how to do do cluster bar charts as a perecentage? Apologies for not being able to supply example pbix. 

[Anonymous]

Hello

I have created one measure for percentage on value and formate that measure into percentage, you can check the below attached screenshot.
I hope you understand the measure for clustered columns as 100% value.

[JosefPrakljacic · Accepted solution]

Hi @steambucky ,

here you have an example file with a measure that should provide the seperation you want. 

Measure = SUM(Example[Value])/CALCULATE(SUM(Example[Value]),ALLEXCEPT(Example,Example[Category]))

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef