Power BI Visuals

[feyyubov]

I have two visuals. Visual A is a matrix that provides the count of the Job_Numbers. When I click on the count values from visual A, my second table visual B brings the related records for the selected number (count of job_numbers). Up until here, everything works exactly how I want. However, when I enter into Visual B and click any of the selected records, the Visual B pulls the entire recordset. I want Visual B to stay as is based on Visual A's selection. Using Edit Interactions I broke a link from Visual B to Visual A, which means, when I use Visual B data, my Visual A matrix does not get impacted. I just want Visual A matrix count selection stay selected, when I navigate through Visual B records.

VISUAL A (matrix):

VISUAL B (table) after I selected 4 jobs from Visual A:

VISUAL B, after I clikc on any records in it (pulls entire record set):

[Idrissshatila · Accepted solution]

Hello @feyyubov ,

It won't work like this as you're explaining, what I would recommend is to have table B in a drill through page and you drill through a record from table A that will filters table B and then you can click on table B without having the issue you're facing now.

[v-shex-msft · Accepted solution]

HI @feyyubov,

Current the focused visual highlight effects not able to keep if your interaction with other visuals. They will lose the focus and restore the original effects.

If you want to keep these, I'd like to suggest you change to use slicer/filter to interaction with other visual, and they will not lost the filter effects if you leave the current visual.
Regards,

Xiaoxin Sheng

[feyyubov]

Thank you, sir! I did exactly ho you recommended and works even better 🙂

[Idrissshatila · Accepted solution]

Hello @feyyubov ,

It won't work like this as you're explaining, what I would recommend is to have table B in a drill through page and you drill through a record from table A that will filters table B and then you can click on table B without having the issue you're facing now.

[feyyubov]

Thanks, @Idrissshatila !