Forum Discussion
Solved
Conditional formatting on boolean values billable v non billable
OK, I have come to a complete stop and frustration.... I have timesheets that are sorted in data column 'Billable' False or True I am trying to create reports to seperate this but I am at a ...
Hi NicDidds
you can use matrix and use billable true/false column, or if you want to use conditional formating you can convert your true/false column to integer and use it for conditional formatting as below.
Measure = SELECTEDVALUE( table[Column] ) + 0Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Hi NicDidds ,
You need a measure as below:
Measure = SELECTEDVALUE( 'Table'[Column1] ) + 0Then in the table visual,right click on the column field>choose conditional formatting>Background color:
Then make the setting as below:
And you will see:
For the related .pbix file,pls click here.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hi NicDidds
you can use matrix and use billable true/false column, or if you want to use conditional formating you can convert your true/false column to integer and use it for conditional formatting as below.
Measure = SELECTEDVALUE( table[Column] ) + 0
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.