Forum Discussion

AvPowerBI's avatar
AvPowerBI
Icon for Post Patron rankPost 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 dat...
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

AvPowerBI's avatar
AvPowerBI
Icon for Post Patron rankPost 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
Icon for Community Champion rankCommunity Champion
4 years ago

No,

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

  • AvPowerBI's avatar
    AvPowerBI
    Icon for Post Patron rankPost Patron
    4 years ago

    I have created a measure instead (though the field I am using is a Date field?)

     

    End Date 2 =
    IF(
    ISBLANK(MIN('Fact'[End Date]))," ",MIN('Fact'[End Date])
    )
     
    This is the result it is showing for the Card visual when using this new Measure End Date 2
     

     

    Has it something to do with my DAX or not possible with Date Types

     

    • aj1973's avatar
      aj1973
      Icon for Community Champion rankCommunity Champion
      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