Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
cainr6
Regular Visitor

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?

2 ACCEPTED SOLUTIONS
Ritaf1983
Super User
Super 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.

Ritaf1983_0-1688093201783.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
Ritaf1983
Super User
Super 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.

Ritaf1983_0-1688093201783.png

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Got it. Thank you!

Glad to help 🙂

(and to be for the safe side , you are putting your measures parametr on values object )

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors