Forum Discussion
How to develop a table that highlights all items in common
Hello BI community,
Does anyone know how to develop a table that highlights all items in common?
Example:
We have a dataset:
| Column1 | Column2 |
| 1 | a |
| 1 | b |
| 1 | c |
| 2 | a |
| 2 | b |
| 2 | d |
| 3 | a |
| 3 | e |
| 3 | f |
If we select 1 ,2, 3 on the slicer we should get:
| a |
| b |
| c |
| d |
| e |
| f |
So that we get all the items and "a" is highlited
or
If we select 1 ,2 on the slicer we should get:
| a |
| b |
| c |
| d |
So that we get all the items and "a" and "b" are highlited
I manged to do it, but instead of highlighting it displays the highlighted items in a separate table and the user is required to select the slicer twice. Example: slicer1: (123), slicer2: (1), slicer3: (2), slicer4: (3):
Please respond if you know how to implement in a more user-friendly way. Using hierichy tree instead of the table would be even better
You cannot do conditional formatting for font boldness, only for font color.
See attached for a possible implementation
You can use a Sankey visual instead
see attached
5 Replies
- lbendlin
Super User
You cannot do conditional formatting for font boldness, only for font color.
See attached for a possible implementation
- lbendlin
I don't understand what you are trying to achieve. Please provide sanitized sample data that fully covers your issue. Please indicate which visual you are using.
The visual I used in the previous reply is:
Let me demonstrate what I need with the default Power BI Hierarchy Tree:
We are given this dataset:
1 a 1 b 1 c 2 a 2 b 2 d the problem is that the hierarchy tree allows only this kind of visual:
Do you know if there is some third-party hierarchy tree or a feature of the default one that allows this:
Thanks!