Conditional Formatting not is not working

[sreyes10]

Good day,

I have created a report and some tables with a conditional formatting. With one table, I had the option to select wheter it is a number or a percentage. 

However, I have tried to create a new table with its conditional formatting. It didnt appear the option to select number and it wasnt working. I also tried with other reports and I think this conditional formatting is not working.

Do you know what is happening? I hope you can help me. 

Thank you very much

[v-yuta-msft · Accepted solution]

@sreyes10 ,

I would suggest you create a new calculate column using dax below and do the summarization operation on the new column:

New Column =
IF ( Table[Boolean] = TRUE (), 1, 0 )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Create a measure that return color and use like

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-not-working/m-p/827603

[sreyes10]

Hello,

But I need to put a background in the field. It could be possible?

[littlemojopuppy]

What @amitchandak  suggested could work...sample code from something I worked on

ProgramEnrollmentStatusColor = 
    SWITCH(
        ProgramEnrollments[ProgramEnrollmentStatus],
        "Active", "#3FB3E2",
        "Completed", "#47C0BA", 
        "Expired", "#E5417A",
        "Abandoned", "#FCD722",
        BLANK()
    )

Substitute the status with your values and you can Google for the hex codes for the colors you want.

After you create the column/measure for the color, in conditional formatting you want to format by field value.

[littlemojopuppy]

Data type issue?  The second one has values of 0 and 1...is that a Boolean field?

[sreyes10]

Hello,

It could be a boolean, however it is 0 or 1, and I need the sumaration.