Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Team,
Lets suppose I have 3 countries and 4 products spread across countries as below -
Country A | Product 1 |
Country A | Product 2 |
Country A | Product 3 |
Country B | Product 2 |
Country B | Product 3 |
Country B | Product 4 |
Country C | Product 3 |
Country C | Product 4 |
I have a product slicer And a matrix table with heirarchical columns as Country --> Product.
When I filter on slicer as Product 2, the matrix table should give the result as
Country A | Product 2 |
Country B | Product 2 |
BUT it gives the result as
Country A | Product 1 |
Country A | Product 2 |
Country A | Product 3 |
Country B | Product 2 |
Country B | Product 3 |
Country B | Product 4 |
All occurences of filtered countries are appearing. Anyway to restirct the matrix table visual to show only the items with Product filtered and NOT all occurences?
Thanks in advance
Solved! Go to Solution.
Hi @mohd_k52 ,
According to your description, you need to put the product field in the value area. Refer to the following result.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mohd_k52 ,
According to your description, you need to put the product field in the value area. Refer to the following result.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.