Need to create slicer to switch between 2 similar data sets

[iGWizard]

Hi,

I've built 2 separate power bi sales validation reports. One is for Units, the other is for Value.

Each report imports the .csv files automatically and then carries out identical processing steps on each.

The columns are identical in both files. I just seen the data to be dynamic depending on slicer selection.

I want to combine these reports and have a slicer option to flick between Units & Values, pulling in the data depending on the filter selection to the matrix.

How can I make this possible? Surely its fairly straight forward as I have both reports built separately and functioning as expected.

Thanks

[audreygerred]

Hello! If you have a measure for Units and a measure for Valu already, you can create a field parameter and  add these two measures (and any others you may want). Once you have the field parameter created, you will add it to a slicer and you will add it to the values section of your visual. The example in this documentation uses dimension fields, but you can use measures: Use report readers to change visuals (preview) - Power BI | Microsoft Learn

[iGWizard]

Hi, thanks for the response 🙂

Currently each data set is stored as a table. No measures currently set up. I presume I need to create measures which reference each of the tables and then create a parameter with each of these?

Thanks

[audreygerred]

Yup! You got it!