Rule out multiple selection

[zoltanm]

Hi All,

I have a `matrix preview` table chart in my dashb. with MARKET_IDs in the column header, KPI_IDs in the row headers and with values.
My only request is to show only one Market at a time, so I added a slicer for the MARKET_IDs & turned on single selection

.But even now people can choose multiple Market ids in the slicer(with the ctrl button), then the matrix table shows - obviously - all the chosen markets in diff columns.

Is there a way to rule this out, and make the matrix chart to go blank, if multiple selection was made?

Rgrds,

Zoltan

[MFelix · Accepted solution]

Hi @zoltanm,

How is your values in the matrix calculated trough a measure? If so you can probably change you measure to something like this:

Measure =
IF (
    CALCULATE (
        COUNT ( TABLE[MARKET_IDs] ) <> 1,
        ALLSELECTED ( TABLE[MARKET_IDS] )
    ),
    BLANK (),
    SUM ( TABLE[COLUMN] )
)

 The SUM ( TABLE[COLUMN] ) is the measure you want to show.

Regards,

MFelix

[zoltanm]

Thanks @MFelix, exactly what I was looking for!

Rgrds,

Zoltan