The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a slicer on my dashboard that needs to only filter one graph and single column in a matrix. So far I have the slicer's interactions limited to the graph and matrix in question, but I cannot figure out how to limit the interaction in the matrix itself. Is there a dax solution that would create new columns to populate the matrix so that the other three column do not change when the slicer is utilized?
The only column in the matrix visual that should be effected by the slicer is the Exception column. The other three should remain unaffected.
Bonus points if you can also help me figure out how to dynamically change the name of the Exception column to match the selection from the slicer as it changes.
Hi @gaby004 ,
What is your desired output? What did you do to cause this result? What measure was created? I'm sorry, I don't quite understand what you mean.
How to Get Your Question Answered Quickly
Please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.