Forum Discussion

Frequent Visitor

8 years ago

Solved

Change x-axis categories dynamically

Our idea is to change the x-axis dynamically based on a slicer selection. Is this possible, via some DAX measure ? Kind regards, Ola Sample file: DOS sample file.pbix We have two ...

Ola
8 years ago
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

Resident Rockstar

8 years ago

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

Frequent Visitor

8 years ago

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