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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
JuanMartin
New Member

Conditional formatting clustered columns

Hi everyone, I need your help, google and chatgpt said there is no function like this in Power BI but I can't believe that.

 

I want to create a clustered column graph that has a conditional formatting on the columns. I'm working with issues created and resolved in a Jira project (with only two issue types) and I want to paint in a different color part of the column that refers to issues created with Issue type A and the rest of the column with issue type B, so for me to know of the total of issues created/resolved how much is from each issue type.

 

I found that stacked column has this feature, but I cannot have more than one column for each month in the graph. For example, the picture below only shows issues created, and I want a column next to that one in the same month that reflects issues resolved but adding more measures to the y-axis only adds more data in the same column. I google and use ChatGPT for conditional formatting and the only solutions that I found was this stacked column, and an option that was "Data Colors" that's no longer available and I found nothing on conditional formatting.

 

 

a.jpg

 

I need the Dark blue and Dark purple to be in the same column and the light blue and light purple on the same one as well, so instead of having 4 columns, only have 2.

 

b.jpg

Thanks and regards.

2 REPLIES 2
elitesmitpatel
Solution Supplier
Solution Supplier

Please share the dummy PBIX file .

Ritaf1983
Super User
Super User

Hi @JuanMartin 
According to your description, the functionality you need is not conditional formatting, but the grouping stacked column chart .
Please refer to the linked video guide for the workaround to achieve it...
https://www.youtube.com/watch?v=AI3eT1kRje4

If my answer was helpful please give me a Kudos and accept as a Solution.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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