Forum Discussion
Conditional formatting - data bars based on other field?
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
- Greg_DecklerCommunity 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
- v-chuncz-msftCommunity Support