Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
etsot
Frequent Visitor

Filtering Matrix By slicer

Hi community,

 

I'd like to built a matrix which will be filtered by several slicers.  I want to apply visual-level filters to the matrix to control which columns appear or disappear based on slicer selections. What is the best solution?

2 REPLIES 2
audreygerred
Super User
Super User

I love utilizing field parameters and calculation groups to give end users some control over what they see in a visual. Check out these blog posts about the two (they also have links to more detailed instructions):

http://powerbiwithme.com/2023/08/04/the-field-parameter-edition/

http://powerbiwithme.com/2023/08/10/the-calculation-group-edition/

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





ChiragGarg2512
Super User
Super User

Use field parameter.

 

Reference this:

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.