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:

     

     

danextian's avatar
danextian
Super User
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: