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

[amaaiia]

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 from slicer. That is, by default visualization has to be hidden. I've checked visualization properties but I can't see a visibility option. I was thinking in a measure like this: 

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

And enabling visualization if this measure >0. But I don't know how to achieve this.

Any ideas?

[v-pnaroju-msft]

Hi amaaiia,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi amaaiia,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft · Accepted solution]

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.

[v-pnaroju-msft]

Hi amaaiia,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[rohit1991]

Hi @amaaiia ,

There isn’t a built-in way to completely hide a visual based on a slicer selection, but you can simulate it using a DAX measure and a clever use of card overlays or shapes.

Here’s how you can do it:

1. Make a measure to count the slicer selections:

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

2. Create a flag measure:

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

3. Use this flag to show/hide your visual:

Option A – Card Overlay (recommended): Add a Card visual on top of your chart/visual. Set the Card to display a message like “Please select a slicer value.” Go to the Card’s Format > Background > fx, and set background transparency with [ShowVisualFlag]. When [ShowVisualFlag]=1, set transparency to 100% (invisible). When [ShowVisualFlag]=0, set transparency to 0% (visible)

Option B – Shape Overlay: Draw a rectangle over your visual and do the same transparency trick using [ShowVisualFlag]. (Heads up: a shape overlay can block slicer clicks if it’s in front, so Card is usually smoother.)

Option C – Return BLANK() from your measure: If you want your visual to go empty when nothing is selected:

DisplayValue = IF([ShowVisualFlag]=1, [YourMeasure], BLANK())

If you want, you can even add a message or instruction on the Card so users know they need to pick something from the slicer.

[amaaiia]

Hi,

That's what I've done, the problem is that as the shape is in front of the slicer, the shape gets transparent but I can't click on it to select values, I click de transparent shape. I can't put it in the back because it wouldn't hide the slicer..

[v-pnaroju-msft]

Thank you, @ibarrau ,for your response.

Hi amaaiia,

We would like to check if the solution provided by @ibarrau has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

Thank you.

[ibarrau]

Hi. As user experience a good idea is to show the place of the visual with instruction and when clicking on the slicer changing the login, hide and show. You can follow this tip to make it happen:
https://blog.ladataweb.com.ar/post/685148133462884352/powerbiux-mensajes-respaldando-blancos

The rule of the measure can be done in different ways depending on how you want to handle.

I hope that helps,