Forum Discussion

Pradeep160's avatar
Pradeep160
Frequent Visitor
1 year ago
Solved

Field parameter with switch

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 comb...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    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's avatar
Ritaf1983
Super User
1 year ago

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.