Date Measure - graph with multiple years and % for each year

[tvathis]

Hi!

I'm trying to create a clustered column chart that can show the % of each year, not the % of all years combined.  

I currently have the 3 years seperated.

I can add a filter to show each year seperately, but when I put all 3 years in the same graph it changes the % values.

I do not have any measures set up at this time.  

Here is my current graphs.  

I'm very new to Power BI and am not sure how to get it to calculate.  

Any help would be greatly appreciated.  

Thank  you! 

[amitchandak]

@tvathis , try a measure like

divide([Measure], calculate([Measure], filter(allselected(Date) , Date[Year] = Max(Date[Year]) ) ) )

[tvathis]

Do I need to create a Measure first? or where it says Measure, would I put the field in there? 

[BrianConnelly]

It can be a measure or an aggregation where he has [Measure].  But do yourself a favor, look at the introduction free training here...Introducing DAX Video Course - SQLBI.  This will really help you get up to speed.

[tvathis]

Thank you so much!