I've just started working with SSAS Tabular model and i faced a big problem. I don't know how to create parameter that will switch dimensions in my table.
User gets drop down list (Category, Sub Category, Version etc.)
If he chooses Category - it will become the first column in table, if he chooses Version it will replace Category and etc
In normal mode (without Cube) it's quite easy - create calculated field and parameter.
What i've discovered after reading all topics is that in cubes I can't use dimensions in calculated field, second thing is that i can't use parameters in MDX...
So is there any way to switch dimensions dynamically in cube models?
Thanks in advance!
Have you tried calculated members as explained here?
You may also want to upvote on the 2 ideas mentioned in the above link.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...