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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
prasadsuzie
New Member

Conditional Formatting- colour by rule not working in Power Bi

Hi, I'm wondering if someone can help me figure out why my conditional formatting isnt working in Power Bi.

I need to colour code this by Y axis - Mark- My datatype is Whole Number for this.

See below Condition: 

Im using Average because that would bring the whole number as I dont want the Sum or Count.

The count only gives me how many students got 6 or 4 which I dont want. I need students who scored 6 to be Green and so forth,

 

prasadsuzie_0-1684305480737.png

 

Display- it hasnt updated any colours - its only reading RED. Please help

prasadsuzie_1-1684305582840.png

 

 

 

5 REPLIES 5
prasadsuzie
New Member

Hi Ritaf, sorry I wont be able to. I have a lot of Tabs running for this Dashboard and its not a sample data , but I can check and send some screenshots for you if you like?

 

Hi @prasadsuzie 
I just don't understand what you need to do.
Isn't it possible to prepare a small example without using your actual data?
So I can explain and demonstrate how conditional formatting works

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

Hi @Ritaf1983 so here's what I'm trying to achieve. I have a list of assessments and Marks. I have put the Marks on Y and AssessmentName on X. I want the conditional formatting to colour code the bar graph according to the marks the students get. 

I have set the condition and sent screenshot in my 1st query. I hope i'm making sense. Please let me know if there's anything wrong that I am not understanding about Conditional formatting?

 

I have set the Marks datatype as whole Number so in condtion i have selected Average (because this will return the exact mark) 

Also I am using SQL query to get data.

My apologies, but I need examples that I can work with to help (not screenshots).
You can find tips on how to attach it to the question in the post on the link below.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

 

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

Hi @prasadsuzie 
Could you please share a sample data / PBIX file?

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.