Forum Discussion
Highlighting a cell Dynamically
- 1 year ago
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. - 1 year ago
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.
I tried both solution. Doesnt work for me.Bi-directional and measure, or may be I just dont know how to do it. I will try later.
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.
- v-ssriganesh1 year agoCommunity Support
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.- NeoChau1 year agoFrequent Visitor
Thank you so much. Works like magic!!!!