Forum Discussion

sreyes10's avatar
sreyes10
Helper I
6 years ago
Solved

Conditional Formatting not is not working

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 c...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    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.

sreyes10's avatar
sreyes10
Helper I
6 years ago

Hello,

 

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

littlemojopuppy's avatar
littlemojopuppy
Community Champion
6 years ago

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.