Show or Hide a Visual Based on Slicer Selection

Anonymous · ‎09-11-2019

Hello everyone,

Is it possible to create a measure that sends a Card behind a table if I have selected a single value in the slicer?

Here's my problem:

I have a page with a table and a card that should show values only if a slicer had a single value selected.

To solve this, I used the formula:

SlicerCheck = if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")

That I found in this topic:

But this measure does not work with the Card, only with the table.

Searching a little more, I found this "solution":

Basically I can create a card that becomes transparent when I have a value selected in the slicer.

But the transparent card is in front of the table, preventing me from clicking to trigger spotlight mode, for example.

Any ideas on how to solve this problem?

Best Regards

v-juanli-msft · ‎09-12-2019

Hi @Anonymous

A workaround is as below:

Resize the table visual as below

Turn off the "Visual header" option for the card visual

Put card visual on top of table visual, group them (new feature since 2019/8, more details here)

Save and publish to Power BI Service

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎09-12-2019

Hello @v-juanli-msft , thanks for your help.

Unfortunately, my PBI is still in the June update. Software updates at the company I work take a while to happen 😞

v-juanli-msft · ‎09-12-2019

Hi @Anonymous

You could download lastest version here. It is free.

The new version always supports older version Power BI files.

After changing reports with new version Power BI Desktop, you could publish the report to Power BI Service to replace the old one.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources