Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
Hi Team,
I have a slicer with 3 dropdown values (company name) and a dependent matrix visual with corresponding Locations,sales and profit. I have a requirement as follows:
In addition to the normal slicer-matrix interaction, when I select company 1, I should get data of only 5 pre-defined company locations. For company 2 and 3, it should work as normal.
All the data including company name, location, sales and profit are taken from the same table.
Please help me for the solution..!!
Thanks in advance 🙂
Hi @Anonymous ,
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more detail information or share me with your pbix file after removing sensitive data to help us clarify your scenario?
How to provide sample data in the Power BI Forum
Best Regards,
Eyelyn Qin
@Anonymous Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |