Forum Discussion
simuruge
6 years agoRegular Visitor
Field or Dimension Toggle
Hi All,
I need help in creating a toggle between two columns based on condition.
Here is an example:
In my table I have three columns, Region , Area and Sales.
In the visualization section:
I would like to create a geograpy slicer where I would like to have a toggle between Region and Area.
If I select Region then the table viz should pull in region column and sales column.
If I select Area, I should be able to see Area wise sales. (Area column and sales coulmn)
Is there a way to achive this via dax insted of making changes in the model by unpivoting stuff?
Thanks,
Sid