The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
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
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
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
Got it. Thank you!
Glad to help 🙂
(and to be for the safe side , you are putting your measures parametr on values object )