Forum Discussion

simuruge's avatar
simuruge
Regular Visitor
6 years ago

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