Highlighting values based on slicer

[cynthiaAA]

Hello,

I've been trying to figure this out for a while and would appreciate any suggestions!

I have the following tables, which have a relationship between the Description columns. 

Table1

Office	Description
Alpha	A
Beta	B
Gamma	B

Table2

Description	Output
A	1
B	2
C	3

In my report, I have two visuals: a slicer on Table1[Office] and a table listing Table2[Description].

I want to highlight the rows in the table visual based on the description. For example, if I were to select Office Alpha in the slicer, I would want the table visual to highlight the row containing "A" in the Description column. 

Thank you!

[bcdobbs · Accepted solution]

You could do something along the lines of this:

https://m.youtube.com/watch?v=DLq5i1mlFqg

[cynthiaAA]

Hi @aj1973 

I did a bit of research into bookmarks and from what I understand your suggestion is to create a bookmark for each office. If this is the case, the list of offices is quite long and that wouldn't be feasible. To be a little more clear, I would like the row of the table visual to appear in a different colour if the office selected from the slicer does in fact have that description. It would look similar to this:

Please let me know if I misunderstood you and you meant to use the bookmark feature in a different way 🙂

Thank you!

[aj1973]

@cynthiaAA 
Yes, it is understood and you are right it is not feasable when the list of description is long. However I don't think it is acheivable otherwise as the slicer is made to filter rows and keep only what is filtered.

I will keep looking as well as you if something more suitable comes on my way 🙂

[aj1973]

Hi @cynthiaAA 

In my understanding you want to Highlight the row without filtering when using the slicer! I would recommend using Bookmarks for this.