Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
THENNA_41
Post Partisan
Post Partisan

How to use custom bar color in Simple water fall chart

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.

 

 

THENNA_41_0-1639982763791.png

 

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

 

THENNA_41_1-1639982937991.png

 

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

 

THENNA_41_2-1639983087286.png

 

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 . 

1 ACCEPTED SOLUTION
v-kkf-msft
Community Support
Community Support

Hi @THENNA_41 ,

 

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

 

vkkfmsft_0-1640229142053.png

 

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.

 

View solution in original post

6 REPLIES 6
v-kkf-msft
Community Support
Community Support

Hi @THENNA_41 ,

 

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

 

vkkfmsft_0-1640229142053.png

 

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.

 

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

Hi @THENNA_41 ,

 

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

Manage Power BI visuals admin settings 

 

Best Regards,
Winniz

amitchandak
Super User
Super User

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

@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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors