This could be a problem of Power BI Desktop versions. My laptop had November 2018 installed but my desktop was still on September 2018 (when I opened it from the EXE and not from a PBIX). When I opened my data-filled PBIX that had been saved using November 2018, it says on the Help/About/ page that the version is November 2018. However it doesn't show the Advanced Controls - perhaps because the underlying software is still September 2018??
So I then tried to upgrade the desktop to November 2018, It uses Microsoft Store and tells me "This product is installed." This is where it went wrong a while back - because I assumed when I got that message that it had already upgraded. When I click on Launch it shows November 2018. Great. However, when I go back and double click my icon in my Start Menu it launches September 2018. Sigh...
Avoiding the dreaded Microsoft Store and using Advanced Download Options, I installed the latest November 2018 on the desktop. Then I opened my data-filled PBIX expecting now to see the Advanced Controls - but they are not there. When I open Power BI Desktop from the EXE (without any data) and create a new connection and visual, the Advanced Controls still don't show! And yet you clearly can see it.... have you got a secret version???
I then turned on all the preview features and tried again. Still nothing.
However, if I turn my Column chart into a Scatter chart, it appears.
Thanks @TomMartens - your points are right. When you add a column to the Legend it switches off the Data Colors control. Then if you take the column out, the Data Colors control is active again. Although this feature is an improvement, it does not provide enough colour control for me.
I was really hoping that MS was announcing a way for me to control colours using DAX and data values held in a column. I can see that you have that for the simple chart (with no Legend). But my charts nearly always use the Legend to show an extra dimension.
Instead, I will have to continue using manually assigned colours for each value of the Legend. Very painful, especially when the Legend value changes when a different client connects via RLS. Each client has to be tested and manually assigned a value before going live.
Anyway, thanks for your help! It clarifies this area of column/bar charts and colours - so I've marked it as Solution.
since the expression based formatting is implemented you will find the option to color filled maps here:
I created a mesure to highlight the state Washington:
fill red if washington =
var isWashington = SELECTEDVALUE('Dimension City'[State Province] , BLANK())
IF(isWashington = "Washington" , "Darkred" , "lightgrey")
I assigned this measure like so:
of course all the previously available color settings are still there, but now integrated into the feature conditional formatting, but nevertheless, this is how filled map will look like with the measure applied:
Hopefully this answers your question.
Hamburg - Germany If I answer your question, please mark my post as solution, this will also help others. I accept Kudos :-), If you find my post helpful.