Forum Discussion
Date Heirarchy does not maintain proper sort
Full disclosure lots going on here. I have built a dyamic legend using dynamic relationships. I have two measures responding to that legend variable. I have a bubble chart where X axis is a date h...
Read about the DAX feature "Sort one column by another column" and then add a QuarterSort column to your calendar table that you then sort the quarter by.
It appears the issue is with the graphic, more research into scatter charts tells me that the x and y axes need to be measures. I tried a number of 3rd party scatter charts and they also had the issue. It's a shame because I think the display is pretty handy. I ended up only offering the users year. No qtr/month drilling. I think for this occasion it will be OK.