Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago
Solved

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 wo...
Need Help
  • JoHo_BI's avatar
    JoHo_BI
    8 years ago

    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's avatar
JoHo_BI
Responsive Resident
8 years ago

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's avatar
DavidB023
Helper III
8 years ago

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's avatar
    JoHo_BI
    Responsive Resident
    8 years ago

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

    • DavidB023's avatar
      DavidB023
      Helper III
      8 years ago

      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