topic How to use custom bar color in Simple water fall chart in DAX Commands and Tips

How to use custom bar color in Simple water fall chart

Anonymous — Mon, 20 Dec 2021 06:56:20 GMT

i am using Simple water fall in my Report . i have used many measure in simple water fall cahrt . i am trying to custom color bar in simple water fall chart.

Now my Waterfall chart looks like below . starting inventory,End inventory,YE targat i have set as define pillars.

Now i want to use Blue color In only YE target . i am trying to change color after the trun on format using sentiments .

i am able to see only four type color format in bar color like below

is there any possible to use custom color particular YE target.

My YE target measure

YE target Month =

CALCULATE(SUM('Master Data Base'[Value]),'Master Data Base'[Reduction buckets]=" Glidepath RF11",'Master Data Base'[Month]="Nov")

thanks in advance .

Re: How to use custom bar color in Simple water fall chart

amitchandak — Mon, 20 Dec 2021 09:00:10 GMT

Anonymous , I doubt there is an option for conditional formatting for sentiment color in waterfall

Re: How to use custom bar color in Simple water fall chart

Anonymous — Mon, 20 Dec 2021 09:03:07 GMT

amitchandak sir i am simple water fall chart. i didnt find any option for conditional fomat . i am using all the value as a measure sir

Re: How to use custom bar color in Simple water fall chart

amitchandak — Mon, 20 Dec 2021 09:25:54 GMT

Anonymous , I think there is no option for that in waterfall visual

Re: How to use custom bar color in Simple water fall chart

v-kkf-msft — Thu, 23 Dec 2021 04:14:39 GMT

Hi Anonymous ,

The Simple Watefall visual supported recolor the bars in versions prior to 2.0.10.3.

For some reason it is not possible to recolor the bars in version 10.3. I found the following explanation of this problem from the developer of the visual.

https://github.com/nishantjainuk/SimpleWaterfall-PowerBI/issues/75#issuecomment-991867927

nishantjainuk commented:

When releasing version 2.0.10.3, I had to upgrade the visual to the latest api which has resulted in these errors. I have fixed these for now and requested for version 2.0.10.4 to be released. Unfortunately, this can take upto 4 weeks for Microsoft to release the new version.

In the mean time, if you need a temporary fix, you can use the beta version of the custom visual, although I highly recommend you to wait for the release from Microsoft

If you do decide to go ahead with the beta version, please note it will import a completely new visual (it will have the same icon) and you will have to update your report and point it to the beta version.

I also recommend that once the new version is released by Microsoft, you repoint your reports to the AppSource version and remove the beta version from your reports.

If you need help how to import a visual directly into your report, please google it.

To download the beta version, please use this link.

You can use version 2.0.10.2, this is the result of my test, I can recolor the bars after turning off the "Format using Sentiments" option.

Import a visual file from your local computer into Power BI: https://docs.microsoft.com/power-bi/developer/visuals/import-visual#import-a-visual-file-from-your-local-computer-into-power-bi

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to use custom bar color in Simple water fall chart

Anonymous — Thu, 23 Dec 2021 07:42:20 GMT

v-kkf-msft i have tired it . its working local desktop . once report published its getting uncertified visuals error in workspace

Re: How to use custom bar color in Simple water fall chart

v-kkf-msft — Fri, 24 Dec 2021 08:40:08 GMT

Hi Anonymous ,

Because your tenant blocks the loading of custom visuals, please refer to

Manage Power BI visuals admin settings

Best Regards,
Winniz