When I read about the new conditional formatting by values feature in the August 2018 release of Power BI Desktop, my first thought was to write a blog post on how DAX can be used to generate the hex values for colours – but then Daniil Masyluk wrote an excellent post on that (and more) yesterday. I then got curious about what colour names are supported when you use a text name rather than a hex code, and Amanda Cofsky of the dev team told me that the official list is the one here:
https://www.w3schools.com/cssref/css_colors.asp
…although there are other names that might work, assuming they don’t contain punctuation. I loaded that list into Power BI and built the following report:
I’ve certainly learnt a few new colour names from this!
Thanks for mentioning me! 🙂
don’t forget the color “SharePoint” – #0072C6
Just kidding… 🙂
very Helpful thanks, cheers from Costa Rica 🙂
I have just tried Emerald and Erin and they are not working as expected. haven’t tried rest, wondering if most of them will work except standard colors such as green, blue etc..
Thanks – yes, it looks like something has changed… let me see if I can find out what.
I recreated my Power BI report and lots of colour names are still supported but Emerald and Erin are no longer on the list of CSS colours shown here; https://www.w3schools.com/cssref/css_colors.asp
Hi Chris,
Could I get this Power BI file you created?