Force Card to show nothing if slicer is blank

[craigmon]

Hi Guys, is there a way to force a card to show nothing if the 'department' Slicer is left blank?  Thanks

The column feeding the card is a per below:

Concate = if(Dept_Rank_Summary[Col2]="", "", CONCATENATE(Dept_Rank_Summary[Rank3], " "& "(" & Dept_Rank_Summary[Col2]) & ")")

[v-xiaotang]

Hi @craigmon 

Have you solved your problem? If yes,  could you kindly mark the answer helpful as the solution? 
If not, could you provide more details about your problem? so that we can work on it further. Thanks.

Best Regards,
Community Support Team _ Tang

[v-xiaotang · Accepted solution]

Hi @craigmon 

sorry for the late reply, you can try this

Concate =
VAR _selDepartment =
    SELECTEDVALUE ( table[department] )
VAR _calculation_when_slicer_is_not_blank =
    CONCATENATE ( Dept_Rank_Summary[Rank3], " " & "(" & Dept_Rank_Summary[Col2] ) & ")"
RETURN
    IF (
        ISBLANK ( _selDepartment ),
        BLANK (),
        _calculation_when_slicer_is_not_blank
    )

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@craigmon add as a measure:

Test = 
IF ( 
   HASONEVALUE ( Dept_Rank_Summary[Department] ), 
   if (
       MAX(Dept_Rank_Summary[Col2])="", "", 
       MAX(Dept_Rank_Summary[Rank3]) & " (" & MAX(Dept_Rank_Summary[Col2]) & ")" 
   ), 
   "Select a department" 
)

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Try to replace "" with ISBLANK()/BLANK(), that is IF(ISBLANK(Dept_Rank_Summary[Col2]),BLANK(),CONCATENATE(...))

[parry2k]

@craigmon make sure to add this as a measure:

[craigmon]

Thanks for that although i'm not really sure i I put the below as a measure as its a text column?

Concate = if(Dept_Rank_Summary[Col2]="", "", CONCATENATE(Dept_Rank_Summary[Rank3], " "& "(" & Dept_Rank_Summary[Col2]) & ")")

[parry2k]

@craigmon you can use HASONEFILTER or HASONEVALUE 

Test = IF ( HASONEVALUE ( Table[Column] ), <<your logic>>, "Select a department" )

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[craigmon]

Thanks for that. I must be doing something wrong as the below just continues to show select a department

Test = IF ( HASONEVALUE ( Dept_Rank_Summary[Department] ), if(Dept_Rank_Summary[Col2]="", "", CONCATENATE(Dept_Rank_Summary[Rank3], " "& "(" & Dept_Rank_Summary[Col2]) & ")"), "Select a department" )