Help with column chart categorization

[LuisM1]

Hi all

Currently i have a survey that runs annualy. At the moment i have the values as % of grand total. I wish to have a % of year total instead.

Is there a way to do this through a measure?

Here is the visual

The orange bars should add to 100% and the blue bars should add to 100%

Thank you

[Anand24]

Hi @LuisM1 ,
This is completely doable in Power BI by creating calculated measures using DAX code.
Can you provide some sample data so that we can help?

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn