How to hide the visual in powerbi when we dont have data

[BhavaniK]

Hi Team, I'm looking for a help to achieve this logic. I have Timertable with 2 columns(Value and Sector).

Value	Sector
1	Sector1
2	Sector2
3	Sector3

As of now, I have a visuals with timer every 30 seconds it will flicker the screens for Sector 1, sector 2, sector 3.

In this, if we don’t have any one of the sector don’t have a data then that visuals should not appear in the screen. Is that possible to do?

[BhavaniK · Accepted solution]

I'm able to complete the task by own. But not sure how to close this request.

[v-karpurapud]

Hi @BhavaniK 

Thank you for the update. If you have found a solution, please share it here, as it will help other community members facing similar issues. Looking forward to your response.

Regards,
Karpurapu D.

[v-karpurapud]

Hi @BhavaniK 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to @Irwan and @danextian  for offering helpful suggestions.

Could you let us know if the suggested solution resolved your issue? This information can assist other community members facing similar challenges.

Thank you.

[danextian]

Hi @BhavaniK 

This isn't possible. You cannot hide visuals based on certain values. You can only conditionally format the values inside (conditional formatting not supported on headers) or use a shape as what @Irwan had suggested. Of course, that approach won't work if the user needs to interact from the visual as what will be clicked is the shape.

[Irwan]

hello @BhavaniK 

i dont think you can do this directly but you can tweak your visual

the step are :

1. put a shape on top of your visual that you want to hide

2. assign color code using conditional field value, when there is a value then transparent color on that shape while there is no value then put a color that same as your background color

as sample data above, value 3 of column1 has no/blank value on column2

if there is no shape, then the visual will be shown as blank value like below

a simple measure to assign color such as below (you can change as you need)

Measure =
IF(
    SELECTEDVALUE('Table'[Column2])=BLANK(),
    "#FFFFFF",
    "#FFFFFF00"
)

Hope this will help.

Thank you.