Forum Discussion

pabad-ap's avatar
pabad-ap
Regular Visitor
1 year ago
Solved

Conditional format on Card(new) with small multiples

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 🙂

Need Help

4 Replies

  • robertto's avatar
    robertto
    Regular Visitor
    1 year ago

    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's avatar
      pabad-ap
      Regular Visitor
      1 year ago

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

    • Etagoe's avatar
      Etagoe
      New Member
      1 year ago

      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.