How to use format function

[vazino]

Hello all,

I'd like to improve the formule below so that I can display "no value available" in the graph when no country has been selected. (with my formula when no country are selected the graph is empty).

I've tried several options with the format function but without success.

My formula :

KPI = if(HASONEFILTER(source[REGION.Country name]);CALCULATE(SUM(source[Current value]);FILTER(source;source[INDICATOR.Indicator name]="KPI"));0)

If someone can help that would be great! 🙂

Thanks a lot

[v-lili6-msft]

hi, @vazino

     You can add a measure as below:

measure = IF(ISFILTERED( source[REGION.Country name])=BLANK() ,"Please Select a Report Date", [KPI])

and then drag it into visual

result:

here is pbix, please try it.

https://www.dropbox.com/s/idxpd57gt16f6x2/How%20to%20use%20format%20function.pbix?dl=0

and this is the problem that I've seen it before, you can refer to:

https://community.powerbi.com/t5/Desktop/Switch-condition-or-If-and-Else-If-to-handle-both-condition...

Best Regards,

Lin

[Greg_Deckler]

You aren't going to be able to mix text and numeric data in a measure. You will want to overlay a card visual that is either blank or "no value available" depending on whether a country is selected.