Forum Discussion

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

Conditional format on Card(new) with small multiples

Hi everyone,

 

I had an issue I couldn't figure out how to fix. I don't know if is a visual limitation or my issue.

My report for an events company track how many invoices are sended to and paid by the customers (companies that rent a stands in the events).

I've created a Card(new) to know the percentaje of invoices paid (Facturado) against total invoices and I added the field "event name" to small multiple. 

After that, I created a format function to determine the color of the percentaje shown (color = if( [Facturado] =1, "green", "red")), but when I apply it, all the small multiples take the same color when last item should be green.

The funny thing is that if I build the same visual in a Matrix and apply the same conditional format, the format works as expected.

Any idea why it happen?

4 Replies

  • pabad-ap's avatar
    pabad-ap
    Regular Visitor

    HI Ritaf1983,

    I've created another post because for a moment this one desapeared. That post has also the link and detailed explanation of the issue but here is the link to a Sample of the report.

    The conditional format on Card(new) was applied in the Visualizaitons Pane of the element, inside Visual > Callout values > Values > Color

    For any extra requirement let me know.

    Thanks in advance

  • docnel90's avatar
    docnel90
    Regular Visitor

    I am having same issues. The conditional formatting is active when there are no small mulitples on the new card. I believe its a bug that needs to be fixed.

  • AleSota's avatar
    AleSota
    Frequent Visitor

    Hi, 

    I'm experiencing the same/similar issue. 

    The conditional colouring for details is not dynamically changing according to the small multiples. 

    How can we fix this?

    Thanks