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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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