Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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/#conditionalFormatting - MS have introduced an Advanced Control...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    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

     

     

    1. Mark the column chart
    2. From the formatting section, activate the Advanced control from the Data colors band
       
    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:

    This leads to this column chart:

    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 

     

     

     

     

     

     

     

     

TomMartens's avatar
TomMartens
Super User
7 years ago

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

 

 

  1. Mark the column chart
  2. From the formatting section, activate the Advanced control from the Data colors band
     
  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:

This leads to this column chart:

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 

 

 

 

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

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... :smileyhappy: 

 

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??? :smileyhappy:

 

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks.