shaikhrulez
Active Member
Hello everyone, I have created this dashboard using power pivot with prime focus and calculation based on dates and grouping of years. The problem is order of axis changes with different slicer selection. I want to display axis in ascending order. I tried reordering/sorting the axis manually by left clicking and using Move option but the order again gets disturbed with different slicer selection.
For example, in chart for Remaining Years in Retirement it must be < 1 year, 1 to 5 years, 6 to 10 years, 11 to 15 years and so on with N/A in the end. Similarly, in chart for Duration of Employees at Current Place of Posting it must be < 3 years, > 3 years, > 6 years and so on with N/A in the end.
Any solution or work around to solve this?
Thanks.
![74723 74723](https://chandoo.org/forum/data/attachments/74/74815-9c89398ca167942742e65e9b244cbaf2.jpg)
For example, in chart for Remaining Years in Retirement it must be < 1 year, 1 to 5 years, 6 to 10 years, 11 to 15 years and so on with N/A in the end. Similarly, in chart for Duration of Employees at Current Place of Posting it must be < 3 years, > 3 years, > 6 years and so on with N/A in the end.
Any solution or work around to solve this?
Thanks.
![74723 74723](https://chandoo.org/forum/data/attachments/74/74815-9c89398ca167942742e65e9b244cbaf2.jpg)
Last edited: