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.
Is there a way to add columns to a matrix and take them away by using filters. So for example if I had a filter called products with A, B and C and chose products a and b the matrix would only show a and b for the columns. So I want the users to be able to choose the columns they see in the matrix.
Hi @poweruser55 ,
You can try slicer visual in power bi.
If the end user selected product A, and the matrix table will only show the product A.
Slicers in Power BI - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, but that is not what I am trying to do. I want to combine multiple products into one column while also showing the other colums @v-chenwuz-msft
Hi ,
Please check this Solved: Dynamically change columns in Matrix - Microsoft Power BI Community community post
Regards,
Ritesh
Please mark the answer if it helps you so that it can help others as well
I am not sure that is the same thing. I want to combine products into one field giving one number instead of seeing them separately, I know I can do this in the transform data but I don't know what formula I would use. @ribisht17
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |