cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

Color Saturation missing on all charts

I am using 2.71.5523.941  32-bit (July 2019) version.

I cannot find Color Saturation option on any chart. I tried lot of options but no luck.

I found below link but even this is not working for me. 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map 

Few blogs says that I need to update Power BI but I think I am on the latest version. 

Can anyone help please?

1 ACCEPTED SOLUTION

Hi @Anonymous 

To use the conditional formatting in column chart, please note:

don't add column in the "Legend" field,

Click on the three dots on the right of the "default color" to open the conditional formatting.

Capture10.JPG

4.png5.png

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
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

9 REPLIES 9
atin
Resolver I
Resolver I

I am also having the same problem. I recently downloaded Power BI desktop and version number is 2.71.5529.0

 

I am trying to use the color saturation field in a map visualisation and the feature no longer appears to exists.

 

Please can I get an alternative solution

 

 

Many thanks

 

 

Anonymous
Not applicable

Hi  @atin 

 

Please refer to below link and solution provided by Maggie.

 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/ 

 

Color saturation on visual is now available under Format tab >Data colors > Click on 3 dots > Conditional formatting. You will not find color saturation in field tab. 

 

Please make sure you do not have any column in the "Legend" field and you will see the coditional formatting option.

 

Note: Please refer to few screenshots which are attached in this forum for reference.

 

Thanks

Archis

v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

As per this blog, in 2018 November release of Power BI Desktop, all the visuals that previously used color saturation are upgraded to have the same conditional formatting experience as table and matrix currently has. You can use conditional formatting feature instead of color saturation.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Thank you Maggie.

 

I understand that Color saturation has been replaced by Advanced Controls which includes conditional formatting but I cannot see Advanced Control Option in the Visualization > Data Colors Section.

 

Any clue?

 

Advanced color option.png

Hi @Anonymous 

Which visual do you use?

Do you add data in the visual and the color option still missing?

 

Best Regards
Maggie

Anonymous
Not applicable

Hi Maggie, 

 

Thats right. Please find below all screenshots from Visualization. I am trying to change the color of the bar which is more than 100%. I hope this helps. Am I doing anything wrong? I still cant find that Advanced Controls option under Data colors

 Visualizations.pngVisualizations1.pngVisualizations2.png

Graph.png

Hi @Anonymous 

To use the conditional formatting in column chart, please note:

don't add column in the "Legend" field,

Click on the three dots on the right of the "default color" to open the conditional formatting.

Capture10.JPG

4.png5.png

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Awesome Maggie.

 

Thank you so much for your time and help. I have access to conditional formatting now 🙂 

Anonymous
Not applicable

I understand the color saturation has been changed and now advanced control option is available under the Data Colors but unfortunately this option is not available in my Power BI.

Can someone please help. Thank you
Color formatting.png

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors