Forum Discussion
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 loss how to do this.
Help please - greatly appreciated
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!
5 Replies
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
Boolean can be treated as 1 and 0. Try with that.
Sorry... I am a complete beginner!
I have no idea what that means.
Is there a measure I can create ?
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!
