Change Measure based on Slicer Value

[Anonymous]

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 selects 2019 on the Slicer is displays another Measure 2019 Outlet Status. 

Basically I just need 

IF('Period Select'[Period Select]= "2019"

then [2019 Outlet Status]

ELSE [2020 Outlet Status]

END

Im having an issue becuase I am not calculating anything- its just classifying outlets. 

Thanks!

[Anonymous · Accepted solution]

@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.

[amitchandak]

@Anonymous , You have try very similar to what have been done here

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464

or

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115