Forum Discussion
Change x-axis categories dynamically
Solved it with a ' resonable work-around', via PQ:
1. I unpivot the two columns, (which duplicates all rows) but
2. I set a Chiclet slicer to require a selection, and
3. I then just have pay attention to the duplicates, and everything should be fine.
Thanks for all suggestions
Hi Ola,
A Calculated Column can't be changed dynamically by the slicer. Maybe this is what you want. Add two columns in the axis. You can change the axis by click "Go to next level".
Best Regards!
Dale
Thank for the reply Dale. Sorry to say, is not a hierarchy.
It is two completely unrelated ways to group countries.
I wish to switch between the two groups, as two different views.
... via a Calculated Measures, or some trick or ... ?
I was hoping for something like =SELECTEDVALUES() that could return some sort of "Calculated measure-array/table", or...
Do you think it is possible ? Or is that 'the limit of DAX' ?
I do not think that this is possible, however the new Bookmarking feature would allow you to provide this type of functionality.
You can create a bookmark for your 3 possible axis scenarios and then navigate to the different scenarios using the bookmarks well.
link below describes bookmarking in detail.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-bookmarks/.
Good luck
Solved it with a ' resonable work-around', via PQ:
1. I unpivot the two columns, (which duplicates all rows) but
2. I set a Chiclet slicer to require a selection, and
3. I then just have pay attention to the duplicates, and everything should be fine.
Thanks for all suggestions
