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

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