Forum Discussion

bobbob123's avatar
bobbob123
Helper III
1 year ago
Solved

Trigger Bookmarks using Slicer

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 ?

Need Help
Show and Tell
  • techies's avatar
    techies
    1 year ago

    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" 
    )

4 Replies

  • techies's avatar
    techies
    Super User
    1 year ago

    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's avatar
    danextian
    Super User
    1 year ago

    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's avatar
      bobbob123
      Helper III
      1 year ago

      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's avatar
        danextian
        Super User
        1 year ago

        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).