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 guys. Long time listener, first time caller.
My problem is that I can't get the date hierarchy with just the year showing to sort in descending order, and when I try to switch the header to be a text column of the year it breaks my measures. I have tried sorting the date hierarchy column and adding a key to sort it properly and neither worked.
For my data set, I'm showing current year and prior year data for a measure that is built to only show the MTD and PYMTD. Here's the formula:
I'm curious about why adding a key to sort it by didn't work. That's what I'd usually recommend for this problem. Something simple like (0-YEAR([date])) would get you the order you want. How/why did it fail to meet your needs?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |