Field parameter with switch

[Pradeep160]

Hey Power BI Community, 

I am currently working with a Matrix visual where I have placed a field parameter, which we can call Parameter1, in the values section. This parameter is created by combining five measures in a specific sequence.

I have received a new requirement to add a switch on the page with two options: Option1 and Option2. By default, Option1 is selected, and with this selection, Parameter1's output should be displayed on the matrix. If the end user selects Option2, I need to display a different field parameter, which we can call Parameter2, consisting of another set of five measures, on the same matrix visual.

I would like to achieve this without using Bookmarks. I have tried several solutions but have not had any success so far. Any assistance or suggestions would be greatly appreciated. Thank you in advance for your help

[danextian · Accepted solution]

Hi @Pradeep160 

Add all fields to the same field parameters table then add a calculated column that groups this parameter fields.

The calculated column and field parameters can be used together in the same slicer, but they should not be used together in a matrix or table because grouping will not be applied. Essentially, these parameter fields are still measures that have not been materialized in a disconnected table using a conditional measure (the old-school approach for switching between measures based on slicer selection). If you do, the result will be as below:

[Ritaf1983]

Hi @Pradeep160 
If I understood you correctly you can use the grouping of field parameters like in the linked video :
https://www.youtube.com/watch?v=qlhcN3A0HNU

if not 

Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to

How to provide sample data in the Power BI Forum

If possible, upload a simplified .pbix file using this guide:

 How to upload PBI in Community

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.