Random sort in Card (new)

[Ulrik_Kofod]

I have encountered an issue using the Card (new).

It worked fine, but when I added a simple conditional format to the value of one of my KPI's it automatically sorted as the first element in the list, and not the 6th as it was designed.

The option I activated was this one

Visual --> Callout Values --> Values --> fx by the color

I based the condition only on the value itself - below or over 0.

As soon as I disabled the conditional format, it went back to the original sorting.

Have anybody seen this issue as well? Is there a known solution?

[Anonymous]

Hi @Ulrik_Kofod,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.

[Anonymous]

Hi @Ulrik_Kofod,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @Ulrik_Kofod,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous · Accepted solution]

Hi @Ulrik_Kofod,

Thank you for reaching out in Microsoft Community Forum.

Please follow below to resolve the issue;

1.Reapply the desired sorting after adding conditional formatting by using "Sort ascending" or "Sort descending."

2.Make sure the field used for sorting is the same as the one being formatted.

3.Remove conditional formatting and check if sorting returns to normal.

4.If sorting issues persist, create a separate measure for conditional formatting rather than formatting the value directly.

Please continue using Microsoft Community Forum.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.