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
Krcmajster
Helper IV
Helper IV

Conditional formatting stacked column chart with multiple vlues

Hi, 

 

Is there a way to put conditional foramting on stacked bar chart with multiple values.

 

I want to highlight 1 or 2 specific columns in the chart  so that they stand out somwhow. Problem is when I add 2 values I no longer have the posibility to add conditional formating. Any other way of highlighting or making them stand out is fine.

2 REPLIES 2
v-xuding-msft
Community Support
Community Support

Hi @Krcmajster ,

 

I’m a little confused for what values to be added while conditional formatting?   If you have more than one values in values fields, there is no option of conditional formatting directly.  But it will display all the columns ,then you can change the colors.  And if you want to add values in conditional formatting, you can choose Format by Rules. If I understand incorrectly, please post your expected result. We can help you as soon as possible.

 

  1. Many values  in values fields. You  can change the colors directly.

0.jpg

  1. Add values in conditional formatting . you can choose to format by rules and add multiple values . Click  Format -- >Data colors -- > Conditional Formatting

1.png2.jpg3.jpg

In this way, you can reference this document to learn more.

 

In addition, You can turn on Show all, then all the values will be displayed.

4.jpg

Best Regards,

Xue Ding

 

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

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

@v-xuding-msft  Thanks. The first chart that you used I want to conditionally format but, as I tought and you have mentioned, it is not possible to conditionally format. 

 

Here is the problem:

You are comparing your company to few other based on classes of workers (HR, Finance, Sales etc.)

And you would use the first visual you have added, with many values in values field. But you want your company to stick out, so when you are comaparing your company to let's say 20 others your eye can instantly catch it insted of reading every X axis lable. Any workaround would be great as well.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.