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

    Gold Contributor
    Posted Jul 11, 2019 04:58 PM
    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
    ------------------------------
    Conference-PBI_200x200


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

    Top Contributor
    Posted Jul 11, 2019 06:16 PM
    https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

    Hope this helps,
    William

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

    Conference-PBI_200x200


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

    Gold Contributor
    Posted Jul 12, 2019 07:27 AM
    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
    ------------------------------

    Conference-PBI_200x200


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

    Top Contributor
    Posted Jul 12, 2019 09:38 AM
    Edited by William Rodriguez Jul 12, 2019 01:12 PM

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

    Conference-PBI_200x200


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

    Gold Contributor
    Posted Jul 12, 2019 01:14 PM
    Great!
    Thanks a lot William!

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

    Conference-PBI_200x200