Forum Discussion
Highlighting a cell Dynamically
Hi NeoChau,
Thanks for your patience.I’ve reproduced your scenario in Power BI and was able to achieve the expected outcome based on your requirement:
- When a user selects a Tag (e.g., Cafe), the related Case No entries are visually highlighted in the Case table without filtering out the others.
This is done using a DAX measure with conditional formatting, as recommended earlier. The interaction from the Tag visual to the Case visual remains disabled to preserve the full list of cases, while relevant rows are highlighted dynamically.
For your reference, I’m attaching the working .pbix file.
I trust this addresses your needs. If it does, please “Accept as solution” and give it a "kudos" to help others find it easily.
Thank you.Hi NeoChau,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
Hi NeoChau,
Thank you for reaching out to the Microsoft Fabric Community Forum.
Power BI natively highlights using visual interactions, where selecting a value in one visual filters or highlights related data in other visuals. However, since you’ve disabled the interaction from the Tag visual to the Case visual to prevent filtering, you can’t use the default highlighting behavior. This is expected, as disabling interactions stops the filter context from propagating to the Case visual.
To achieve your goal, you can use a DAX measure combined with conditional formatting to dynamically highlight rows in the Case table based on the selected tag, without filtering the table. This is the most effective and scalable solution for your scenario.
If you find this information useful, please “Accept as solution” and give it a "kudos" to assist others in locating it easily.
Thank you.
Thanks for your explanation.
How to do it exactly?