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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Conditional formatting row by row

Hi,

 

I need to conditional formatting row by row.

 

linkinprak71_0-1673187487308.png

 

1 ACCEPTED SOLUTION

Hi,

Please check the below picture and the attached pbix file.

Jihwan_Kim_0-1673238364856.png

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

I need this as below, back ground colors min, mid and max values on row by row

 

linkinprak71_1-1673230148350.png

 

 

 

Hi,

Please check the below picture and the attached pbix file.

Jihwan_Kim_0-1673238364856.png

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.
Anonymous
Not applicable

Hi 

 

I use that code but cannot please me again

 

linkinprak71_1-1673604535139.png

 

Ahmedx
Super User
Super User

do you need it like this?

Screen Capture #208.png

Padycosmos
Solution Sage
Solution Sage

Are the back ground colours based on specific rules, such as range of values ?

Jihwan_Kim
Super User
Super User

Hi,

One of ways to achieve this is to create a rank measure ( by row) and then conditional format it by the rank measure.

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your data model.

 

Jihwan_Kim_1-1673193233492.png

 

 

 

 

 

 

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Hi, 

As I'm new to Power BI may I know what do we need to write in (Subject[Subject]) & [Value measure:]

Anonymous
Not applicable

Hi,

 

I mean individual row by row.

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.