Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@tvathis , try a measure like
divide([Measure], calculate([Measure], filter(allselected(Date) , Date[Year] = Max(Date[Year]) ) ) )
Do I need to create a Measure first? or where it says Measure, would I put the field in there?
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.
Thank you so much!
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |