Highlighting a cell Dynamically

[NeoChau]

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 B (Tag Library)

Tag_ID	Description
0001	Cafe
0002	Park
0003	Apartment
0004	Train Station

Table C (Case & Tag)

Case No.	Tag_ID
01-24	0001
01-24	0002
02-24	0001
02-24	0003
03-24	0001

All tables are joined together with the related key.

In my report:

There is a title search visual, a table visual "A" showing all filtered cases (From Table A) and a table visual "B" showing all tag tagged with the filtered cases.

After the user inputs the criteria for the title search, say "Arson".

Visual "A" will be like this

02-24 Arson

03-24 Arson

Visual "B" will be like this

0001 Cafe

0003 Apartment

If the user selects/clicks on 0001, I want to highlight the 02-24 and 03-24.

If the user selects/clicks on 0003, I want to highlight only 02-24 (because 03-24 doesn't have the tag 0003).

How to do this? I've been struggling with this for two days...

[v-ssriganesh · Accepted solution]

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]

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.

[NeoChau]

Thanks for your explanation.

How to do it exactly?

[v-ssriganesh]

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.

[v-ssriganesh]

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.

[NeoChau]

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.

[v-ssriganesh · Accepted solution]

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 · Accepted solution]

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.

[NeoChau]

Thank you so much. Works like magic!!!!

[NeoChau]

@LED_GeneralI dont want the case table be filtered after user selected the tag. I disabled the interaction from the tag visual to case visual. I just want the case table to be highlighted based on user selection on tag visual

[LED_General]

It should filter automatically if you select the row in B. Screenshots would be helpful.

[NeoChau]

Please please please. Could anyone help?

[LED_General]

I think you could try to make the relationships bidirectional (which is normally discouraged, but in your case it could check if it works).