Forum Discussion
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.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
- Ritaf1983Super User
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.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- cainr6Regular 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
- Ritaf1983Super 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