Empty visual

[DavidB023]

Hi everybody !

I would like to make empty my visual when I don't choose a date in my slicer.

In fact I used :

 IF (
    DISTINCTCOUNT ( XXXX ) = 1;
    SUM ( XXX);
    ""
)
And it worked very well with value like figures !

However, it don't work with value like text and I am embarrassed with that ..

Thanks
Best regards

David

[JoHo_BI · Accepted solution]

Hi @DavidB023,

Use the DAX function HASONEVALUE() here, an example would be: 

IF(HASONEVALUE(TextTable[Text]), VALUES(TextTable[Text]), "Or i'll do this..")

Hope this helps! 

[DavidB023]

@JoHo_BI


Thanks for your answer, it seems okey to work, when I selected nothing, nothing appear but now when I select a value, #,0.00 appear in place of my real value..

[JoHo_BI]

I can't reproduce the problem. Can you show a screenshot or share a file at all? 

[DavidB023]

@JoHo_BI


My value are dates, so I just have to modelize them as a date and it sucess !

Thanks very much

Best regards

David