cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
belvoir Helper V
Helper V

Data Colors Advanced Controls, November 2018 release

Hi there,

 

In the November 2018 release at - https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#conditional... - MS have introduced an Advanced Control for Data Colors, for conditional formatting. It's supposed to be a link on the Data colors dropdown section in the Formatting area.

 

It currently only appears on Scatter Chart, Tree Map, Map, Filled Map and Funnel. However Amanda Cofsky says in her blog that it would be available for all variants of column and bar charts.

 

Has it been held back or have I misunderstood something?

 

I have checked that I've on the very latest version! I don't think I need to set one of the Preview checkboxes....?

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Data Colors Advanced Controls, November 2018 release

Hey,

 

please excuse, but I do not fully understand what you are asking for.

 

If you wonder how to activate this advanced control for a simple column chart, this may help:

The next screenshot shows a column chart, without any conditional formatting

image.png

 

 

  1. Mark the column chart
  2. From the formatting section, activate the Advanced control from the Data colors band
    image.png 
  3. Select a formatting "rule", in my example I select "Format by: Field value ..." and select a measure that returns the name of a color:

    image.png

This leads to this column chart:

image.png

This is the DAX for the measure:

vis aid - fill color - mark category b = 
IF(HASONEVALUE(Table1[A])
    ,IF(FIRSTNONBLANK('Table1'[A],0) = "B"
        ,"darkred"
        ,"darkgrey"
    )
    ,BLANK()
)

If this does not answer your question, please excuse, and please rephrase your question, that I will be able to provide more guidance if not an answer.

 

Regards,

Tom 

 

 

 

 

 

 

 

 

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.

Proud to be a Datanaut!

View solution in original post

9 REPLIES 9
Super User III
Super User III

Re: Data Colors Advanced Controls, November 2018 release

Hey,

 

please excuse, but I do not fully understand what you are asking for.

 

If you wonder how to activate this advanced control for a simple column chart, this may help:

The next screenshot shows a column chart, without any conditional formatting

image.png

 

 

  1. Mark the column chart
  2. From the formatting section, activate the Advanced control from the Data colors band
    image.png 
  3. Select a formatting "rule", in my example I select "Format by: Field value ..." and select a measure that returns the name of a color:

    image.png

This leads to this column chart:

image.png

This is the DAX for the measure:

vis aid - fill color - mark category b = 
IF(HASONEVALUE(Table1[A])
    ,IF(FIRSTNONBLANK('Table1'[A],0) = "B"
        ,"darkred"
        ,"darkgrey"
    )
    ,BLANK()
)

If this does not answer your question, please excuse, and please rephrase your question, that I will be able to provide more guidance if not an answer.

 

Regards,

Tom 

 

 

 

 

 

 

 

 

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.

Proud to be a Datanaut!

View solution in original post

belvoir Helper V
Helper V

Re: Data Colors Advanced Controls, November 2018 release

 

Hi @TomMartens - thanks for your help. 

 

That's what I was expecting to see!

 

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... Smiley Happy 

 

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??? Smiley Happy

 

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.

 

Here are some pictures below.

 

Capture.JPG

Capture2.JPG

Capture3.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks.

belvoir Helper V
Helper V

Re: Data Colors Advanced Controls, November 2018 release

Hi @TomMartens

 

Thanks for your comments. Alas, I'm still not seeing it for column or bar charts:

Capture.JPGColumn chart next to About popupCapture2.JPGColumn chart - Data colors

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capture3.JPGScatter plot with Advanced Controls

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

But I am for Scatter Charts.

 

Note that I have installed Power BI Desktop November 2018 version from scratch and the above is new data and a new visual. 

 

It's very odd that you can see it and I can't for column charts. I'm mystified!

 

Thanks.

 

 

 

 

 

 

 

 

 

belvoir Helper V
Helper V

Re: Data Colors Advanced Controls, November 2018 release

I have found one answer: 

 

If you don't put anything on the X-axis then you don't get the Advanced Controls! Once I do, it magically appears!

Capture4.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Sadly however if I put a Legend on, it disappears!

Capture5.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Houston, we have a problem....

 

 

Super User III
Super User III

Re: Data Colors Advanced Controls, November 2018 release

Hey,

 

color saturation wasn't available in column charts, in this cases

  • more than one measure has been selected
  • a column has been assigned to the legend band

If you want to check this out, here you will find all the previous versions of Power BI Desktop:

https://zenatti.net/2017/07/04/power-bi-previous-versions/

 

Regards,

Tom

 

 

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.

Proud to be a Datanaut!
belvoir Helper V
Helper V

Re: Data Colors Advanced Controls, November 2018 release

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.

Aleksandra_K
New Member

Re: Data Colors Advanced Controls, November 2018 release

No advanced controls button in Filled map view, how do I get it to appear ?

bcushway
New Member

Re: Data Colors Advanced Controls, November 2018 release

There is NO option for Advanced controls on my Power BI Desktop 

Screenshot (3).png

Super User III
Super User III

Re: Data Colors Advanced Controls, November 2018 release

Hey,

 

since the expression based formatting is implemented you will find the option to color filled maps here:

image.png

I created a mesure to highlight the state Washington:

fill red if washington = 
var isWashington = SELECTEDVALUE('Dimension City'[State Province] , BLANK())
return
IF(isWashington = "Washington" , "Darkred" , "lightgrey")

I assigned this measure like so:

image.png

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:

image.png

 

Hopefully this answers your question.

 

Regards,

Tom

 

 

 

 

 

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.

Proud to be a Datanaut!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors