How to develop a table that highlights all items in common

[Anonymous]

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

[lbendlin · Accepted solution]

You cannot do conditional formatting for font boldness, only for font color.

See attached for a possible implementation

[Anonymous]

Thank you so much for your solution. It helped a lot! But do you know if it is possible to do the same with the hierichy tree, so that it converges at the items in common.

Example:

Instead of this:

We need this:

[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.

[Anonymous]

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!

[lbendlin · Accepted solution]

You can use a Sankey visual instead

see attached

[lbendlin · Accepted solution]

You cannot do conditional formatting for font boldness, only for font color.

See attached for a possible implementation