Bar chart negative value

[VoltesDev]

Hi,

In a bar chart / column chart, how can we make negative values to have different color ? 

Thanks

[mwegener]

Hi @VoltesDev 

you can do this by conditional formatting on the data color.

[VoltesDev]

@mwegener 

Hmm... yeah I don't have that Function (fx) feature, maybe because I'm still using August 2020 version. I have to use this older version of PBI Desktop because there is some issue with my ERP (which still Pending in Microsoft)

Thanks,

[mwegener]

Hi @VoltesDev ,

which ERP (connector) do you use?
What is the issue here?

[VoltesDev]

I'm using Dynamics 365 Finance and Operations and the issue with the metadata v3 models which announced during Sep 2020 and it is not supported in Dynamics 365 Finance.

It is over 1 year now ->

It is really limits us to use the full features of Power BI.

Thanks

[mwegener]

Hi @VoltesDev ,

I understand the problem. Thanks for sharing.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.