Forum Discussion
Highlighting values based on slicer
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!
4 Replies
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!
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 🙂
