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

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
Highlighted
Super User
Super User

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.
Proud to be a Datanaut!

View solution in original post

9 REPLIES 9
Highlighted
Super User
Super User

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.
Proud to be a Datanaut!

View solution in original post

belvoir Member
Member

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 Member
Member

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 Member
Member

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
Super User

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.
Proud to be a Datanaut!
belvoir Member
Member

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
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 Occasional Visitor
Occasional Visitor

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
Super User

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.
Proud to be a Datanaut!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 333 members 2,963 guests
Please welcome our newest community members: