Display of the entry selected in the matrix visual as the title of another table.

[davfra]

Hello, everybody,

have a matrix visual and a table in a report. Both should interact with each other as follows:

When I click on a row in the matrix visual, the title of the table should be adjusted according to the row selected in the matrix visual.

For example:
If I click on "Michael" in the matrix visual, the title of the table should be changed to "Michael".

Does anyone know how I can solve this problem? Maybe with a DAX expression or a new column?

Enclosed is the sample report:
https://www.dropbox.com/s/6sf4dooy7b5rjuz/pbifile.pbix?dl=0

Thanks for your help.

davfra

[v-cherch-msft · Accepted solution]

Hi @davfra

You may try below measure:

Title =
IF (
    ISFILTERED ( 'Hierarchy'[Level3] )
        && MAX ( 'Hierarchy'[Level3] ) <> BLANK (),
    MAX ( 'Hierarchy'[Level3] ),
    IF (
        ISFILTERED ( 'Hierarchy'[Level2] ),
        MAX ( 'Hierarchy'[Level2] ),
        IF ( ISFILTERED ( 'Hierarchy'[Level1] ), MAX ( 'Hierarchy'[Level1] ), "Title" )
    )
)

Regards,

Cherie

[davfra]

Hi @v-cherch-msft,

thank you, your solution worked!

Regards

Frank

[Greg_Deckler]

You can use a Card visual with a measure as its value. Like this Quick Measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...

[davfra]

Hello @Greg_Deckler

thank you for your answer.

I also thought about using a row card and an additional measure.

However, I don't know how to retrieve the selected row from my hierarchy in my DAX-Measure.

Regards

Frank

[v-cherch-msft]

Hi @davfra

You may create a measure as below. Attached the sample file. Here is the article for your reference.

Title =
IF (
    ISFILTERED ( 'Hierarchy'[Level1] ),
    CONCATENATEX ( VALUES ( 'Hierarchy'[Level2] ), 'Hierarchy'[Level2], "," ),
    "Title"
)

Regards,
Cherie

[davfra]

Hi @v-cherch-msft

thank you for your answer.

The DAX-Measure does not quite deliver the desired result.

If I click on an entry in the matrix on the second hierarchy level, the result is correct, but as soon as I click on a name in the first hierarchy level, I get an enumeration of the children. However, I only want to display the name clicked in the matrix (e.g. Annabel). (Of course, this should also work on the third hierarchy level.)

I also read the article, but it didn't tell me how to solve my problem with a hierarchy.

Thanks for your support.

greetings
davfra

[Greg_Deckler]

Seems like you could just use MAX to grab the single value that is selected in the matrix.