Is there a way to dynamically show/hide a table based on slicer value

[EaglesTony]

Hi,

  I have a slicer with values of Initiative, Epic, Feature.

  There is a table control that shows only Features, thus when the user selects Initiative or Epic, it will hide this table control, but when they select Feature from the slicer, I want to show this table control, is there a way to do this ?

  I'm also ok, if there is a solution to always show the table control, but when the user selects Initiative or Epic, the table will be blank, but when they select Feature it will be populated.

Thanks

[EaglesTony]

 Is there a way to find out what the slicer value is, almost like a after_selected event ?

[SamWiseOwl]

You can reference a single item from a filtered column using SelectedValue(table[columnInSlicer]) or use Values{table[columnInSlicer]) if they have multiple selected.

So for example:
Measure Single = "You selected the " & SelectedValue(Region[RegionName]) & " region"

or

Measure Multiple = "You chose the following regions " & ConcatenateX(Values(Region, Region[RegionName], ", ")

[EaglesTony]

This works!

I'm wondering now if using "Measure Single" = "Feature" can execute a bookmark ?

I have a bookmark that "hides" certain visuals.

[SamWiseOwl]

Sadly not 😞

[EaglesTony]

Maybe I can use something like this: 

Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI

[miTutorials]

Check out this tutorial - tweak the logic to meet your requirements.

Don't show data in a table if nothing is selected in a PowerBI Slicer | MiTutorials (youtube.com)

[SamWiseOwl]

Hi @EaglesTony 

Objects themselves don't have a visability.

However you could:

1. Set a rectangle over the top and set the colour to match the report background or see through.                    If( Count(Features) >0, "Background colour", "#FFFFFF00")
2. Or download a custom visual that supports image URL, use the same calculation to return an image or nothing
3. Set the text to the same colour as the background or return no text with BLANK()

[Idrissshatila]

Hello @EaglesTony ,

check this 
https://youtu.be/a9AMSovkZcI?si=WRk5nOJ93IxkbDcH

https://youtu.be/lqPiYGoQxSw?si=LpHx9XqN24PB2_VF