Conditional format on Card(new) with small multiples

[pabad-ap]

HI everyone,

@AleSota  @Ritaf1983 the other post doesn't exist any more. I'll explain the issue again with an example.

Link to Sample report:  CardNewSmallMultiplesIssue.pbix

Issue: I have a report that track invoices sended to and paid by companies that rent a space in some events.

I've created a Card(new) visual with the field event name as small multiples field and I want to apply a conditional format to "paid_invoices %", green for 100% and red for the other cases. 

DAX measures used are: 

paid_invoices % = DIVIDE([Paid_invoices], [Invoices], 0)

color = if( [paid_invoices %] = 1, "green", "red")

If I apply the conditional format to Card(new), DAX apply the logic over the visual total paid_invoices % insted of over the total of the specific small multiple. But using the same measures in a table the result is the expected one, red for paid_invoices % <1 and green for the other case.

Thanks in advance for your suport. If some extra information is needed let me know 🙂

[robertto]

Identical problem here. Any solution? It has no sense that the visual allows to inform rules, etc etc but then don't apply for each row/card.

[pabad-ap]

As far as I know it is not fixed for the moment. It is in the roadmap of future enhancements.

[Anonymous · Accepted solution]

Hi @pabad-ap ,

As far as I know, conditional formatting is not currently supported for multi-row card. You can consider the following workarounds and submit your suggestion here(Home).

Links:

Solved: Conditional format with multi-row - Microsoft Fabric Community

Solved: Multi Row Card Conditional Formatting - Microsoft Fabric Community

Best regards,

Mengmeng Li

[Etagoe]

I do hope its something that will be remedies in the near future to allow small multiples to support conditional formatting. I had a similar issue but mine is with respect to conditionally formatting the color of the details of a reference label. I have no choice but to use the work around now but it'll be very cumbersome to be using all the time because some of my cards a combination of the small mutliples and bookmarks.