Forum Discussion

cainr6's avatar
cainr6
Regular Visitor
3 years ago
Solved

Field Parameter in Matrix

I have a dataset that has different attributes I would like the user to be able to decide whether or not they want to see. I have a matrix visual. I have added columns to a field parameter and added it to the "values" box. When using the slicer generated by the field parameter nothing changes.

 

When I swith to table visual and move the field parameter to the columns it works as expected. Can you use field paramters to choose the values (and therefore "columns") present in the matrix visual?

  • Hi cainr6 
    Matix works with field parametrs as all other visuals.
    You just need to pay attention that you are creatig parametrs for objects that you need.
    Matrix have : Rows , columns and values.
    You need to deside which of them user can choose and create fiels parametr for avery object separately.

    Link to the sample file 

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

  • Hi cainr6 
    Yes , but they need to be measures...
    for axemple if you putting there total sales and total profits,
    you need to create measure for each of them and this measures will be your fiels parametrs.

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

5 Replies

  • Hi cainr6 
    Matix works with field parametrs as all other visuals.
    You just need to pay attention that you are creatig parametrs for objects that you need.
    Matrix have : Rows , columns and values.
    You need to deside which of them user can choose and create fiels parametr for avery object separately.

    Link to the sample file 

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

    • cainr6's avatar
      cainr6
      Regular Visitor

      Thank you..if I am trying to use my "values" as my "columns" because I don't have anything specified for columns is that possible? That's my situation here...each item I am brining into the "values" field parameter is a separate column I want to display, again, with no actual item in the "Columns" configuration box

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        Hi cainr6 
        Yes , but they need to be measures...
        for axemple if you putting there total sales and total profits,
        you need to create measure for each of them and this measures will be your fiels parametrs.

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