Forum Discussion

amaaiia's avatar
amaaiia
Icon for Skilled Sharer rankSkilled Sharer
1 year ago
Solved

How to enable a visualization only if at least one slicer value is selected

Hi, I'm doing some testing with PafNow Procces Mining visualization. I have a lot of flows to show in the visualizacion, but I want to enable visualizacion only if one or more flows are selected ...
  • v-pnaroju-msft's avatar
    1 year ago

    Thankyou, rohit1991 , for your response.

     

    Hi amaaiia,

     

    To ensure that the visualization remains hidden by default and becomes visible only upon selecting a slicer value, without restricting user interaction, kindly follow the steps mentioned below, as they may assist in resolving the issue:

     

    1.Create the following measures:

    SelectedCount = COUNTROWS(VALUES('Table'[SlicerColumn]))

    ShowVisualFlag = IF([SelectedCount] > 0, 1, 0)

    Ensure that 'Table'[SlicerColumn] corresponds to the relevant slicer.

    2.Add ShowVisualFlag to the PafNow visual’s Filters pane at the visual level.Set it to is 1, ensuring that the visualization remains hidden when no slicer value is selected.

     

    3.Overlay a Card on the Visualization.Use the following measure for the card:

    DisplayMessage = IF([ShowVisualFlag] = 0, "Select a slicer value to view.", BLANK())

    Assign this measure to the card’s Fields pane.

     

    4.Configure the Card’s Background Transparency.Define the following measure:

    CardTransparency = IF([ShowVisualFlag] = 1, 100, 0). 

    Apply this measure using the fx button under Format Visual > Background > Transparency. This ensures that the card disappears when a slicer value is selected.

     

    5.When no slicer value is selected, the card displays the message, and the visualization remains hidden.When a slicer value is selected, the card disappears, and the visualization appears while remaining fully interactive.

     

    If you find this response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

    Thank you.