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.
Thanks for your explanation.
How to do it exactly?
Hi NeoChau,
To achieve the highlighting effect without filtering the Case table, you can create a custom DAX measure that checks if the selected tag is associated with each case. This measure won't filter the data but will act as a flag to indicate which cases are related to the selected tag. With this logic in place, each row in the Case visual can be evaluated to determine whether it should be highlighted when a tag is selected, even though the visual interactions are turned off.
Once the measure is created, you can use conditional formatting in the Case table visual. Select the field you want to highlight (like Case No or Case Title), then apply conditional formatting using the measure as the basis for formatting rules. Set different background or font colors depending on whether the case is linked to the selected tag. This way, the Case visual retains all rows but visually highlights only the relevant ones.
I trust this information proves useful. If it does, kindly “Accept as solution” and give it a "kudos" to help others locate it easily.
Thank you.
Hi NeoChau,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
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.