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 

     

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    7 years ago

    Hey,

     

    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())
return
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.

     

    Regards,

    Tom