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

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