Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi @Anonymous 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
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. 🙂
@Anonymous
You can, if you so wish, display all individual supplier values selected using:
Suppliers selected = CONCATENATEX(VALUES(Slicer_table[column]), slicer_table [column], “, “)
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous 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
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |