Forum Discussion
Conditional formatting on boolean values billable v non billable
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!
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] ) + 0
Then 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.
Kelly