Forum Discussion

pabloignacio123's avatar
pabloignacio123
Regular Visitor
1 year ago
Solved

How to enable sorting by colour indicators in a table without labels

I’m working on a Power BI table visual that uses conditional formatting (colour indicators such as green, red, yellow) to show status for various fields (e.g. Usage Rate, Below Average Last 3 Months,...
Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    dm-p 

    Thanks for your prompt response

    Hi pabloignacio123 ,

    Thank you for the detailed explanation earlier  it was really helpful.

    I’ve implemented the logic as discussed and have uploaded a sample PBIX file for your review. Could you please take a look and let us know if it’s working as expected, or if there’s anything that might need adjustment?

    Looking forward to your feedback.

    Best regards,

    Lakshmi


    Create a calculated column  Status_Code based on Usage Range

    Status_Code =
    SWITCH (
    TRUE (),
    [Usage_Range] >= 0.8, "V",
    [Usage_Range] >= 0.5, "A",
    "R")

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi pabloignacio123 ,

Thanks for reaching out to the Microsoft fabric community forum.

To better understand the issue and build the appropriate logic, it would be very helpful if you could share some sample data that fully represents the problem or question you're referring to.

Kindly ensure the data is:

In a usable format (e.g., Excel or CSV), rather than a screenshot

Free of any sensitive or unrelated information

Looking forward to your response.

Best regards,
Lakshmi Narayana

pabloignacio123's avatar
pabloignacio123
Regular Visitor
1 year ago

Dear Lakshmi,

Thank you for your prompt response and for your willingness to help.

To clarify my question: I am working with a table visual in Power BI where I use conditional formatting (specifically colour indicators—green, yellow, and red) to reflect statuses such as “Usage Rate” or “Performance over the Last 3 Months.” These indicators are based on DAX measures that evaluate specific thresholds or trends.

The colours are displaying correctly; however, I’ve noticed that unless I show a numeric or text label within the cell, users are unable to sort the column by clicking on the header. My aim is to keep the table visually clean—showing only the coloured indicator (for example, a coloured circle or background)—but still allow sorting based on the logic that determines the colour.

Would you happen to know if there is a way to enable sorting in this context, perhaps by linking the conditional formatting logic to a hidden or supporting field?

Please let me know if it would be helpful to share a sample file. I’m happy to prepare one accordingly.

Best regards,
Pablo

  • dm-p's avatar
    dm-p
    Super User
    1 year ago

    Hi pabloignacio123,

     

    Have you considered setting conditional formatting on both the font color and the background color? Having a useful value in the cell (albeit colored out) can help from an accessibility perspective if you have users who use a screen reader, but will still provide the cosmetic effect you want.

     

    Regards,

     

    Daniel

    • pabloignacio123's avatar
      pabloignacio123
      Regular Visitor
      1 year ago

      Yes, I have considered applying conditional formatting to both the font colour and the background colour. Including a meaningful value in the cell — even if it’s visually hidden by using the same font and background colour — can indeed be beneficial for accessibility, especially for users relying on screen readers.

      It's a clever approach that maintains both functionality and visual cleanliness. I’ll explore this further to ensure it aligns with our design goals while supporting usability.

      Thanks for the suggestion!

      Best regards,
      Pablo

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year ago

    dm-p 

    Thanks for your prompt response

    Hi pabloignacio123 ,

    Thank you for the detailed explanation earlier  it was really helpful.

    I’ve implemented the logic as discussed and have uploaded a sample PBIX file for your review. Could you please take a look and let us know if it’s working as expected, or if there’s anything that might need adjustment?

    Looking forward to your feedback.

    Best regards,

    Lakshmi


    Create a calculated column  Status_Code based on Usage Range

    Status_Code =
    SWITCH (
    TRUE (),
    [Usage_Range] >= 0.8, "V",
    [Usage_Range] >= 0.5, "A",
    "R")

    • pabloignacio123's avatar
      pabloignacio123
      Regular Visitor
      1 year ago

      Hi Lakshmi,

      That’s exactly what I needed — thank you very much for implementing the logic and for sharing the PBIX file.

      I’ll review it shortly and get back to you with any observations or suggestions, if necessary.

      Best regards,
      Pablo

      • v-lgarikapat's avatar
        v-lgarikapat
        Community Support
        1 year ago

        Hi pabloignacio123 ,

        You're very welcome  I'm glad to hear it met your needs.

        Please feel free to reach out with any feedback or suggestions once you've had a chance to review the file. I'm happy to make any adjustments if needed.

        Looking forward to hearing your thoughts.

        Best regards,
        Lakshmi