Forum Discussion

petergarry111's avatar
petergarry111
Frequent Visitor
1 year ago
Solved

Matrix Filtering Issue

Hi,    I am looking to be able to make columns in my matrix disappear when they are not selected in the slicer but it seems the data just disappears and the column remains but is blank. I have had ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi petergarry111 ,

    If you are using Matrix visual, only need to put the "parameter" into the Values :

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi petergarry111 ,

Agree with johnt75 , and here are the detailed steps:
Under Modeling > New parameter > Fields:

Select the fields or measures you want to put in:

Put the parameter into the table or matrix visual:


And the final output is as below:



 

Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the replies as the solution to help the other members find it more quickly.

  • petergarry111's avatar
    petergarry111
    Frequent Visitor
    1 year ago

    Thanks for the response! Will give it a try and get back to you 🙂