Hi All, I am currently in the need to create a dynamic X-axis (dimension) without making use of field parameters (Live connection) and bookmarks (too many bookmarks already present). I have created a static table with 4 values and I am trying to create a switch statement as below... but for some reason it is not working:
I need to switch between dimensions..as clearly mentioned above..x- axis should depict category or sub category or region etc based on my slicer selection...and I am guessing that in no way can be defined as a measure...
You can use Field Parameters to swap dimension columns dynamically.
There's no such thing as a dynamic column - well there is, but it's called a measure.
Please explain in more detail what you are trying to achieve.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!