cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
veltsi Frequent Visitor
Frequent Visitor

Card to have value if only one available

Hi,

I'm trying to do a report to have supplier name as header. The same report should serve with only one supplier selected from filter or several. Header is currently a card that shows first value of name column, but the problem is that if user selects multiple suppliers, then only the first is shown.

 

I would like that card to show blank (or maybe "Selected Suppliers") value if multiple values are selected. I already got made a measure to give Y or N depending if more than one is selected but that can't be used as visual filter as it is a measure (correct me if I'm wrong but that gave only frozen filter :)).

 

Card single value check = IF(CALCULATE(DISTINCTCOUNT(SUPPLIER_DATA_TABLE[SUPPLIER_NAME]);ALLSELECTED(SUPPLIER_DATA_TABLE[SUPPLIER_NAME))=1;"Y";"N")

 

One idea is to create blank row to SUPPLIER_DATA_TABLE and sort it by SUPPLIER_NAME, but does anyone have an idea how to get around this problem without changing the source? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Asac_14 Regular Visitor
Regular Visitor

Re: Card to have value if only one available

Hi @veltsi  try using the below measure 

Card Value = IF(HASONEFILTER(SUPPLIER_DATA_TABLE[SUPPLIER_NAME]),FIRSTNONBLANK(SUPPLIER_DATA_TABLE[SUPPLIER_NAME],SUPPLIER_DATA_TABLE[SUPPLIER_NAME]),"All Selected")

 

If it works pls mark this as solution and give a kudos 😉

 

Thanks,

KK

View solution in original post

4 REPLIES 4
Asac_14 Regular Visitor
Regular Visitor

Re: Card to have value if only one available

Hi @veltsi  try using the below measure 

Card Value = IF(HASONEFILTER(SUPPLIER_DATA_TABLE[SUPPLIER_NAME]),FIRSTNONBLANK(SUPPLIER_DATA_TABLE[SUPPLIER_NAME],SUPPLIER_DATA_TABLE[SUPPLIER_NAME]),"All Selected")

 

If it works pls mark this as solution and give a kudos 😉

 

Thanks,

KK

View solution in original post

Super User I
Super User I

Re: Card to have value if only one available

@veltsi 

You can, if you so wish, display all individual supplier values selected using:

Suppliers selected = CONCATENATEX(VALUES(Slicer_table[column]), slicer_table [column], “, “)

 

 

 




If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
Thank you!

Proud to be a Super User!




veltsi Frequent Visitor
Frequent Visitor

Re: Card to have value if only one available

Thank you @Asac_14 . This solves my problem perfectly!

veltsi Frequent Visitor
Frequent Visitor

Re: Card to have value if only one available

Thank you both @Asac_14  and @PaulDBrown for quick replies!

 

As I didn't find autofit text size option for cards I ended up using both of these in two non-background cards stacked. First one shows only if one supplier is selected with a bit modified @Asac_14  code in big font and second one uses both codes combined to show values if multiple vendors are selected with smaller font. Makes effect of scalability in a card. 🙂

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors