topic Re: Date Measure - graph with multiple years and % for each year in DAX Commands and Tips

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

tvathis — Fri, 10 Mar 2023 19:37:19 GMT

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!

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

amitchandak — Sat, 11 Mar 2023 01:18:30 GMT

tvathis , try a measure like

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

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

tvathis — Mon, 13 Mar 2023 18:47:30 GMT

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

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

BrianConnelly — Mon, 13 Mar 2023 19:30:18 GMT

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.

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

tvathis — Tue, 14 Mar 2023 15:59:14 GMT

Thank you so much!