Card value is blank when multiple selections in a slicer

[Anonymous]

Hello!

I'm wondering if it's possible to add a condition and how would it look like that if multiple selections were made to a slicer it shows a blank for this card?

EURO-Emission classification =
SWITCH (

TRUE();

vehiclesettings_BI_LL[Year] < 1992; "No Year";

vehiclesettings_BI_LL[Year] <= 1997 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 1";

vehiclesettings_BI_LL[Year] <= 1998 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 2";

vehiclesettings_BI_LL[Year] <= 2000 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 3";

vehiclesettings_BI_LL[Year] <= 2005 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 4";

vehiclesettings_BI_LL[Year] <= 2008 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 5";

vehiclesettings_BI_LL[Year] <= 2013 && vehiclesettings_BI_LL[MonthNumber] <= 12; "Euro 5";
"Euro 6")

[dedelman_clng]

Hi @Anonymous -

Use HASONEVALUE( )

IF ( HASONEVALUE ( vehiclesettings_BI_LL[Year] ),

    SWITCH(

     .... ,

    "Euro 6"),

"")   //ELSE

Note, this will also show "" if 0 slicer selections are made.

Hope this helps

David

[Anonymous]

I tried using this syntax but it changed all of my Euro values inside the column to Blank and the card also shows Blank as the answer if only one vehicle was selected. Could the problem be that this is a calculated column instead of a measure?

EURO-Emission classification =

IF(HASONEVALUE(vehiclesettings_BI_LL[Year]);

SWITCH (

TRUE();

vehiclesettings_BI_LL[Year] < 1992; "No Year";

vehiclesettings_BI_LL[Year] <= 1997 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 1";

vehiclesettings_BI_LL[Year] <= 1998 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 2";

vehiclesettings_BI_LL[Year] <= 2000 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 3";

vehiclesettings_BI_LL[Year] <= 2005 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 4";

vehiclesettings_BI_LL[Year] <= 2008 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 5";

vehiclesettings_BI_LL[Year] <= 2013 && vehiclesettings_BI_LL[MonthNumber] <= 12; "Euro 5";

vehiclesettings_BI_LL[Year] <= 2014; "Euro 6");

"Blank")

[dedelman_clng]

@Anonymous - if you want any value to change with a slicer, it must be a measure. Calculated columns are only refreshed once when the entire dataset is refreshed.

If you're still having trouble, please share a copy of your PBIX file with sensitive data scrubbed out.

David

[Anonymous]

I changed my syntax to work in a measure and now it works as intended. Thank you for your help!