Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i am trying to create the matrix visual whose values should get changes as per column selection.
i have metrics of countries and brand as matrix column and header. values in the matrix appear as per column selection but i need to create multiple matrix visuals to see each column data in matrix view.
i want some filter or slices which can make this matrix visual dynamic.
Solved! Go to Solution.
Hi @Anonymous
Would you like this result?
Assume your data as below
If so, please unpivot the 10 columns in Edit queries,
Then rename the column "Attribute" as "selection", close&&apply.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Would you like the matrix to show value for many columns when selecting many selections from a slicer?
If so, add the column used in the slicer to the "column" field of the matrix,
when you select many values from sclier, click the icon to expand all levels of the matrix column.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-juanli-msft,
Thanks for your response.
Actually i want the data to update in the matrix visual as per column selection (one at a time). i do not need to have data for multiple column together.
All i need is instead of creating 10 matrix visual per column , i can create 1 which can get updates on column selection.
see snap shot i tried creating to showcase my requirement.
the checkboxes in the right are columns and have values in Green,pending,red and n/a. i need i can get this metrix updated as per columns when i select them but i do not konw how can i map multiple column values with matrix view
Hi @Anonymous
In addition, there are other useful methods which may be helpful.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Would you like this result?
Assume your data as below
If so, please unpivot the 10 columns in Edit queries,
Then rename the column "Attribute" as "selection", close&&apply.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |