Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

How to change color of chart automatically

Jump to Best Answer
  • 1.  How to change color of chart automatically

    Bronze Contributor
    Posted 5 days ago
    Hello,
    In previous version of Power BI desktop, the "Advanced controls" option allowed to change the mix of 2 colors according the value of Data.
    How can we do that now ?
    Thanks and regards

    ------------------------------
    GD61
    ------------------------------


  • 2.  RE: How to change color of chart automatically

    Posted 5 days ago
    https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

    Hope this helps,
    William

    ------------------------------
    William Rodriguez
    Business Analyst | MCSA: BI Reporting
    ------------------------------



  • 3.  RE: How to change color of chart automatically

    Bronze Contributor
    Posted 4 days ago
    Thanks,
    I found Conditional formatting for Table, but i'm seeking Conditional formatting for the bars of a chart (Clustered column chart for example)
    Any idea?
    Thanks again

    ------------------------------
    GD61
    ------------------------------



  • 4.  RE: How to change color of chart automatically
    Best Answer

    Posted 4 days ago
    Edited by William Rodriguez 4 days ago

    Hi @Gérard Ducouret​:

    Whoops!

    Same thing, but Microsoft almost 'hid' the option. In your graph, go to "Data Colors" and when you hover over "Default Color", ellipses appear to the right. Click this and then select "Conditional Formatting".

    Not sure why they hid the feature - seems like an idea we can post to them.

    Again, hope this helps!

    William

    https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting



    ------------------------------
    William Rodriguez
    Business Analyst | MCSA: BI Reporting
    ------------------------------



  • 5.  RE: How to change color of chart automatically

    Bronze Contributor
    Posted 4 days ago
    Great!
    Thanks a lot William!

    ------------------------------
    GD61
    ------------------------------