Conditionally formatting chart

[Matthijs1234566]

Hello,

I want to format my chart in two colours, red and green. 

In one column there are three options to select. For the options cXML and Online is a positive bar in green needed, and red if the percentage is negative. For the paperinvoice it is the opposite. Green bar if the percentage is negative and red if the bar is positive.

How do i fix this?

GraphSort

[Matthijs1234566]

Hello,

I cant share the PBI file, because it contains copmany data. I have made an Excel file, with random data. 

One measure is needed what the difference is between the quarters for each method how many invoices there are. For cXML and Online it have to be red if the percentage is negative and green if it is positive. If the Paperinvoice percentage is negative it must be green and if the percentage is positive it must be red. I hope you have enough information.

The difference have for each quarter needs to be in a bar chart


https://we.tl/t-JI9YFqhada 

[perarajahkumar]

Hi Matthijs,

There are two ways to solve this issue. Click on your graph and select the format option on the right side of your screen. You could set rules for data labels by clicking on the (fx) button. Change the format style to rules and choose the appropriate field on which you would like to base your rules.   

Hence you could say if < 0  percent then (color) red etc...

Follow this link for more help: https://community.powerbi.com/t5/Desktop/Conditionally-format-bar-chart-column-colour-based-on-slice...

Adjusting this slightly will help solving your issues. 

Goodluck

[Matthijs1234566]

This is not the right answer. I have three options: 

In one column there are three options to select. For the options cXML and Online is a positive bar in green needed, and red if the percentage is negative. For the paperinvoice it is the opposite. Green bar if the percentage is negative and red if the bar is positive.

The graph has a dynamic title

[perarajahkumar]

Initially I misunderstood your question. If you could share your pbix file, I can help you out with this. 

I just have to try a few DAX to solve it.