Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
You could do something along the lines of this:
You could do something along the lines of this:
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 🙂
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @cynthiaAA
In my understanding you want to Highlight the row without filtering when using the slicer! I would recommend using Bookmarks for this.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |