Dynamically changing measure based on selection.

[WynandCilliers]

Hi All,

I have 2 columns, Local currency sales, and foreign currency sales. I want to have a selection box (Local / Foreign) and based on that, display all sales across the app off that selection.

Can you please advise how to accomplish this.

Thanks,

Wynand

[Anonymous · Accepted solution]

HI @WynandCilliers,

I think you can take a look at the following blog to use the switch function and measure name to achieve dynamic change display values:

Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer: Parameter Table ... 

Regards,

Xiaoxin Sheng

[amitchandak]

@WynandCilliers ,  I think you need measure slicer

measure slicer
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://www.youtube.com/watch?v=vlnx7QUVYME