How to change color of chart automatically

  • How to change color of chart automatically

    Posted by DSC Communities on July 11, 2019 at 4:58 pm
    • GĆ©rard Ducouret

      Member

      July 11, 2019 at 4: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
      ——————————

    • William Rodriguez

      Member

      July 11, 2019 at 6: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
      ——————————
      ——————————————-

    • GĆ©rard Ducouret

      Member

      July 12, 2019 at 7: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
      ——————————
      ——————————————-

    • William Rodriguez

      Member

      July 12, 2019 at 9:38 AM

      Hi ?:

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

    • GĆ©rard Ducouret

      Member

      July 12, 2019 at 1:14 PM

      Great!
      Thanks a lot William!

      ——————————
      GD61
      ——————————
      ——————————————-

    DSC Communities replied 6 years, 1 month ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘How to change color of chart automatically’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!