Forum Discussion

FValluch's avatar
FValluch
New Member
2 years ago
Solved

Power BI - visual help

Hello, 

as you can see on screen, there is a text "(Prázdné)"("empty") below red smiley. That means, there are no data for this category. For the rest smileys you can see number 2 or 1. 

How to do it such a way that I will see below red smiley "0"(zero) as we have no data(no response) or my own text? 

 

Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    FValluch 

    You can add a condition to the measure as follows ;

    Measure = IF ( ISBLANK( [YOURMEASURE] ) , 0 , [YOURMEASURE] )
  • FValluch's avatar
    FValluch
    2 years ago

    Hello, 

    If I have it, where I should this new measure use? where or how to add it to work correctly ? 

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    FValluch 

    You can add a condition to the measure as follows ;

    Measure = IF ( ISBLANK( [YOURMEASURE] ) , 0 , [YOURMEASURE] )
  • FValluch's avatar
    FValluch
    New Member
    2 years ago

    Hello, 

    If I have it, where I should this new measure use? where or how to add it to work correctly ?