Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |