Trigger Bookmarks using Slicer

[bobbob123]

Hi

I have 1 slicer (year value), 1 visual (any visual) and 1 shape that cover my entire visual.

I want to cover my visual with the 1 shape (set of 50% transparence) unless a user selects a value from the slicer then it will be 100% transparent. 

Is this possible within Power BI ?

[techies · Accepted solution]

Hi @bobbob123 as i understand , you can use the following ShapeFillColor measure and apply it to the shape’s fill color using conditional formatting (fx in the Fill setting)

ShapeFillColor =
IF(
ISFILTERED('YourTable'[Year]),
"#FFFFFF00", 
"#80808080" 
)

[danextian]

Hi @bobbob123

Slicer selections cannot trigger bookmarks. You can create a measure that returns an RGBA color depending on slicer selection and use it to conditinally format the color of a shape. Note: it only affects the color and not whether the shape is hidden or not.

Please see the attached sample pbix.

[bobbob123]

Hi @danextian thats a great approach, but i need just 2 outcomes. if no selection is made, then the background blocks the user from seeing the visual (blurred effect, solid effect etc doesn't matter) and if a user makes a selection then they should be able to see the entire visual. 

[danextian]

You can set the transparency value to 100% by setting the alpha value to 0 depending on slicer selection but please note that since the shape is overlaying the other visuals, users cannot interact with it.  Here's a sample measure to be used in conditional formatting - field value option.

Shape color =
VAR SelectedCount =
    DISTINCTCOUNT ( 'Table'[Column] ) // Count the number of distinct selected values in the slicer.
VAR TotalCount =
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Column] ), ALL ( 'Table' ) ) // Count the total number of distinct values in the column, ignoring slicer filters.
RETURN
    IF ( SelectedCount < TotalCount, "rgba(0,0,0,0)", "white" )
// If the selected count is less than the total count, it means a selection is made, 
// so return fully transparent color "rgba(0,0,0,0)".
// Otherwise, return "white" when no selection is made (all values are selected).