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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
jthomson
Solution Sage
Solution Sage

Conditional formatting - data bars based on other field?

databars.PNG

 

 

Data set is simple - two columns, one showing a category of job, the other saying yes or no depending on whether the job has been settled. Here I've got two measures - one counting the number of jobs that have been settled, the second showing the number that have been settled as a percentage of all jobs.

 

Is it possible to conditionally format the settled column as a data bar using the values of settled%? Both of these columns are formatted using the values of settled%, but if I pick data bars on the settled column it doesn't allow me to change the field it uses to format, I can only use background/font colours, and I'd like the style of the second column. Any ideas? Cheers

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@jthomson,

 

There is already an idea, you may leave a comment and vote it up.

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

Can you post some sample data so that this can be recreated easily? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors