Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
DavidB023
Helper III
Helper III

Empty visual

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

1 ACCEPTED SOLUTION
JoHo_BI
Responsive Resident
Responsive Resident

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! 

View solution in original post

4 REPLIES 4
JoHo_BI
Responsive Resident
Responsive Resident

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! 

@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
Responsive Resident
Responsive Resident

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

@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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.