Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change Measure based on Slicer Value

I have a table that contains YTD, MTD, WTD, and 2019   I want to write a formula that when the user selects YTD, MTD, or WTD on the slicer it displays the measure 2020 Outlet Status, when a user se...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 
    If MTD YTD WTD and 2019 are 4 columns, you would need to create a new slicer table name it as slicer column.

     

    Measure = IF(SELECTEDVALUE('Slicer Table'[Slicer Column])="2019",[2019 Outlet Status],[2020 Outlet Status])

     

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 
If MTD YTD WTD and 2019 are 4 columns, you would need to create a new slicer table name it as slicer column.

 

Measure = IF(SELECTEDVALUE('Slicer Table'[Slicer Column])="2019",[2019 Outlet Status],[2020 Outlet Status])

 

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.