Forum Discussion
Selecting multiple measures with one field parameter selection
Hello community, I am trying to create a field parameter where two measures are added with one selection. I have no idea if this is actually possible. Something along the lines of this: Be...
Hi, I think I have found a solution for this.
I had been trying to select two measures with one field as well (one with the actual data and another with targets), and I managed this by:
- Creating two different field parameters with the fields in the correct order (parameter 1 with real data for fields A, B and C; parameter 2 with targets for A, B and C)
- Estabilishing a relationship between the two parameters based on the hidden index field (this is why order is important)
- Adding only one of the created fields to a slicer
This way, by selecting values on a single slicer you can use both parameters on your visuals.