Conditional formatting on boolean values billable v non billable

[NicDidds]

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

[Mariusz · Accepted 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 · Accepted 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

[amitchandak]

Boolean can be treated as 1 and 0. Try with that.

Also refer https://community.powerbi.com/t5/Desktop/Conditional-formatting-on-boolean-values-filtered-by-multip...

[NicDidds]

Sorry... I am a complete beginner!

I have no idea what that means.

Is there a measure I can create ?

[v-kelly-msft · Accepted solution]

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.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

In filter or in conditional formatting try value as 1 and 0. If this does not work. Can you share sample data and sample output.