Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to create a custom column chart Month on Month with 2 values.1 for selected fiscal year other for last fiscal year.
As you can see from the below image, when I select FY 22-23, column chart should show value for 22-23 and 21-22.
In the card it show correct value ie 1281. But same measure does not work correctly- when used on column chart Month on Month. Expected value on chart should be like the one in table - Apr-284, May-175 and so on but instead it shows Apr - 1281, May-997
Below is the dax that I have written.
Solved! Go to Solution.
Hi @amit_darak,
I suggest using the SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Learn
This makes it easier and can possibly achieve your goal without messing with ALL() since you do not need to ignore filters.
Hi @amit_darak,
I suggest using the SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Learn
This makes it easier and can possibly achieve your goal without messing with ALL() since you do not need to ignore filters.
Hi,
This did work. Just thinking what was wrong in my DAX?
Regards,
Amit Darak
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |