Forum Discussion

NeoChau's avatar
NeoChau
Frequent Visitor
1 year ago
Solved

Highlighting a cell Dynamically

Another highlight problem I got. Thanks in advance for answering my question. Table A (Case) Case No. Case title 01-24 Assault 02-24 Arson 03-24 Arson 04-24 Fraud Table ...
  • v-ssriganesh's avatar
    v-ssriganesh
    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.

  • v-ssriganesh's avatar
    v-ssriganesh
    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.