color management advice

thanks for your suggestion, but its not a conditional on the value of the item, but the identifier/name.   So Product 1 would always be red, even if i was specifiying it as the sales value or units.  The actual values of each are not important, just that Product 1 is always red.  Product 2 always blue etc.  

Hi Parry, 

I got your example to work fine, changing colors by just changing the hex value in the table.  But when i try to use this on my existing pbix file and visuals, I dont get the Fx prompt, just the existing colors.  is there an update that i need to do on the file itself?  the picture on the left is my existing visual for a bar chart, one on the right is your visual in a different file, showing the fx button.  Current PowerBI version is 2.88.1144.0 32-bit (December 2020)

edit: same situation with a brand new file, the fx button doesnt show

thanks!

?  

thanks, i think your solution might do it.  I definitely dont mind if its complex, esp if i can anticpate the need and build the table in code beforehand.  I will take a look at your book, let you know if it works

Hi Tom, 

Thanks for your suggestions.  I did get your book and see how you are able to determine a color based on values within the data, but I am not seeing where to apply it to my visual.  The conditional formmating tab is only visible in select cases, as seen in Parry's example I downloaded.  It appears to be ok if i only select 2 of the three values going into the visual (axis and values), if i select the third, and with any combination, i lose the conditinal formatting ability.  Am I missing something?  almost all of my visuals have a time axis, a legend (products that i want to control colors for) and the values for each product.  Nothing i can see will give me that conditional formatting capacity.  Is this coming in a future version?  mine is currently desktop Version: 2.88.1144.0 32-bit (December 2020) 

also sorry for the messages getting out of sync

conditional formatting tab available and linked to the color fieldworking conditional formatting, but only 2 of 3 data points specifiedadding the 3rd data point breaks the conditional formattingNotice the conditional formatting tab is now missing

Thanks Parry, 

I like your solution, seems pretty straightforward to add a color field to my product table.  I like how it appears to work with the pie chart as long as you start off assigning the function to a bar chart version before switching to another style...seems like a future release would enable conditional formatting for all charts, no? 

hi, attached is my stripped down PBIX, see if you can see how to change it to present the functional color button.  i dont see how to add it as an attachment, here is a dropbox link: https://www.dropbox.com/s/ajcqwh7t4p2nb6q/JW%20color%20test.pbix?dl=0