Forum Discussion

Maithilitiwari's avatar
Maithilitiwari
Frequent Visitor
2 years ago

Hide a visual based on selection from other visual

Hi 
I have a report in which i have two drop down and if selectall option is selected in 1 dropdown i want to hide the another one.

So if select all is selected in NEW/RENEW filter i want to hide Recurring filter if  New or Renew is selected individually i want recurring visual to be visible

Need Help

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    Maithilitiwari , First create two measure

     

    DAX
    IsSelectAll =
    IF (
    COUNTROWS ( VALUES ( 'YourTable'[NEW/RENEW] ) ) = COUNTROWS ( ALL ( 'YourTable'[NEW/RENEW] ) ),
    1,
    0
    )

     

    And

    ShowRecurring =
       IF (
           [IsSelectAll] = 1,
           BLANK(),
           1
       )
     

    Select the Recurring visual.
    Go to the Format pane.
    Expand the Visual section.
    Find the Conditional Formatting option (this might be under Data colors, Background, or another property depending on the visual type).
    Click on the fx button next to the property you want to conditionally format.
    In the Conditional formatting dialog, select Field value and choose the ShowRecurring measure.
    Hide the Visual Based on the Measure:

    If the visual type supports it, you can use the ShowRecurring measure to conditionally format the transparency or visibility of the visual.
    If the visual type does not support conditional formatting for visibility, you can use a workaround by placing a shape or text box over the visual and conditionally formatting its transparency.