NO BLANK want text

Power BI
1

Screenshot 2021-12-03 125759
When selecting a name in a slicer, the state appears in the card. When nothing is selected in the slicer, (Blank) appears. How do you not display Blank in the card when nothing is selected? I want it to say either select value or return nothing.

Thanks

2

CONCATENATEX and ISFILTERED??

3

Airport Location by State =

VAR vALS = CALCULATE ( CONCATENATEX ([Airport Names],

TREATAS(SUMMARIZE(‘Heavy Precipitation’, ‘Heavy Precipitation’[Site Name]),
“,”
)
)
VAR IsItFiltered =
IF ( ISFILTERED ( ‘Airport Names’ ), vALS, “No Airport Selected” )

RETURN
IsItFiltered

4

State Located =
VAR ConCat =
CALCULATE (
CONCATENATEX (
VALUES ( ‘Airport State Location’[State Abbreviation] ),
‘Airport State Location’[State Abbreviation],
“,”
)
)
VAR IsItFiltered =
IF ( ISFILTERED ( ‘Airport State Location’[Data Collection Site Name] ), ConCat, “No Airport Selected” )
RETURN
IsItFiltered

5

Fixed it

1 Like
6

Hello @Paul.Gerber, may we confirm what do you mean by "“Fixed it”?

If you were able to fix the problem, kindly close this thread. If not, you can provide a more detailed explanation as to what you need help with.

This will help other users find a solution for you quickly.

7

Hi @Paul - As your issue is resolved, request you to close this ticket

Thanks
Ankit J

8

How do I close this feed?