asked on May 9, 2024
I have a date dimension and it has a value and a display value. This is so they sorting is correct. Is there a way to have a display value for a value? You can see how ugly the values look on the screen shot.
Any other suggestions so that I can get proper sorting? Take example weekdays. The values would be 0,1,2 but display value would be Sunday, Monday, ... See the issue?
Thanks!
⋅ May 13, 2024
Hello, Marty!
Thank you for reaching out to us.
With Microsoft Analysis Services, we recommend configuring the data types on your cube so the data received by Flexmonster matches the requirements. With the correct data type, Flexmonster will display the days of the week in the correct order, as you can see in this example: https://jsfiddle.net/flexmonster/wL63vyea/
Please let us know if this approach would work for you.
Best Regards,
Maskym
