Slicer based on value columns

[ragty412]

Was hoping to get some help regarding using a slicer to filter between different columns. 

I currently have a SQL script that converts original transaction values into two separate columns. Local Currency and USD Currency. These 3 value fields/columns are in my data table. I currently have a matrix visual that shows the detail of these transactions. The only way for me to switch the values to local currency or USD currency is to add one of those columns to the values in the matrix. I want to add a slicer to filter on eirth transactional,local,USD value columns instead of having to do it manually in the visual 

[MFelix · Accepted solution]

Hi @ragty412 ,

For this you can use Field Parameters:

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters