Forum Discussion

AvPowerBI's avatar
AvPowerBI
Post Patron
4 years ago
Solved

Card Visualization - Do not show (Blank)

Hi,

 

I am using the Card Visulization and one of the fields that I am putting on the field section is called End Date ( I am selecting the Earliest )

 

. 

This End Date does have some dates for some people when I filter on their name but when I select a person that has their End Date as blank it shows it on the Card as the below

 

 

How do I make it just showing nothing i.e. no text just a White Box

 

 

Thanks

Need Help
  • aj1973's avatar
    aj1973
    4 years ago

    If you are talking about selecting a slicer, you want your measurement to come back blank when the row is empty, then do not do it if the condition because you are going to find it blank or you need to add a SELECTED VALUE to your measure.
    Example:

    aj1973_0-1642202695421.png


    Can you share a sample? it would be easier to understand this way

5 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    4 years ago

    Hi AvPowerBI 

    Just white box, no not possible...but you can replace the Blank by some term of your choice, you will need to add a DAX measure using IF condition to the calculation.

    • AvPowerBI's avatar
      AvPowerBI
      Post Patron
      4 years ago

      I created a New Column with the below IF Statement 

       

      End Date 2 =
      IF(
      ISBLANK('Fact'[End Date])," ",'Fact'[End Date]
      )
       
      But it is coming back wit han error message of the following:
       

       

       

      Thanks

      • aj1973's avatar
        aj1973
        Community Champion
        4 years ago

        No,

        You need to add a measure not a calculated column, using Min(date) or EARLIER, EARLIEST...