How to use Slicer to chose which column to filter

[sshen]

Hello, 

I am relatively new to Powerbi. Right now I am working off a datasource that has 1 column that is cases and a different column that is KG for the same product. I want to add a slicer that can toggle between cases and KG and I want my visuals to reflect values of case or KG respectively. Is what I want to do possible? what is my best option here 

[FreemanZ]

hi @sshen 

this is possible with field parameter

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

[sshen]

Tahnk you, that is working but i am not able to visualize it because the KG and cases won't convert to number even though the underlying data are numbers. Do you know why that is? 

[TaylorPBI21]

Hi @sshen, 

could maybe add a product detail table to include product detail and the 2 measurments? And then be able to filter by product with 2 card visuals one total quantity and one Total weight? Could also include them in the tooltips of your visuals?😎