Forum Discussion
Helper Icolor management advice
Hey jwalter10 ,
I wrote the chapter "CHAPTER 8 – Using DAX to solve advanced reporting requirements" that covers exactly your question.
Maybe you want to have a look at the book Phil_Seamark and I have written some time ago:
As the solution is not that simple, please excuse that I do not simple copy the chapter (next to some legal considerations):
Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular: Seamark, Philip, Martens, Thomas: 9781484248966: Amazon.com: BooksThe simple product table:
Regards,
Tom
jwalter10 see attached and you can enhance it from here...The color measure is the key, it doesn't need to be part of the table the way I did it but having it in the product table will make it easier.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Allowing default color values to be specified for a given dimension is essential. Tableau has this exact feature under "Default formatting" for a given dimensional field. And the default behavior in Tableau is to assign only one color for a given dimension value (though color repeats are possible if it's a high cardinality dimension).
That it's even possible to encode the same discrete dimension with different colors across charts is just bad visualization practice. That's why it's crazy that PowerBI even allows this -- it's even crazier that it's difficult to avoid this confusing design.
Helper IAside from recommending Tableau, which I tried using and didnt like, i agree that the color management in Power BI is awful and not consistent at all. I have about 20 visuals in my file, and zero agreement on the colors used. Also they change if I add a new data point. very frustrating and not productive at all