Forum Discussion

HxH's avatar
HxH
Icon for Advocate II rankAdvocate II
7 years ago
Solved

Making a visual disappear when there's no selection

Hy everyone, 
I built a visual with a CLUSTERED BAR CHART that only shows value if there's one selection made in a certain filter. Therefore when I have no selection I would like to have no data at all, to have a blank, clean screen in that position. 

Instead I get this: 



The title is correct but I don't want those lines and those points on the X axis. I know I could disable the gridlines or the X axis alltogether but I like to have them when, instead, I do have a model selected and data on my visual. 

Is there some way I could correct this? Either in the visual's settings or in the DAX I wrote for that formula (which has an IF(HASONEFILTER) condition with a BLANK as the last argument in order to show nothing when I don't have a filter selected). 

Thanks 

  • Hello HxH ,

     

    yes there is a possible solution -> MattAllington describes it here.

     

    If this post was helpful may I ask you to mark it as solution and give it some kudos?

    Have a nice day!

    BR,
    Josef

1 Reply

  • Hello HxH ,

     

    yes there is a possible solution -> MattAllington describes it here.

     

    If this post was helpful may I ask you to mark it as solution and give it some kudos?

    Have a nice day!

    BR,
    Josef