Table Specific column different colour for totals and values

[FotFly]

Hi,

I have a table in power bi in which I have a lot of columns. I have a specific column that is a measure and I want to highlight the values in the column adding different background colour while making the font for the total the same as the background as the measure is not supposed to sum.

Do you know why I cannot set different format for values and totals?

[Anonymous]

Hi @FotFly ,

Power BI does not support adjusting the color of the total value for a column. You can adjust the font color of the total row to match the background color, or turn off the total column.

Could you tell me why you want to hide the total of the measure? If it's because the total of the measure is wrong, you can try SUMX to create another measure to show the correct total.

Here is my test for your reference.

Measure 2 = SUMX(Table,[Measure1])

Best regards,

Mengmeng Li

[FotFly]

Thank you for the reply. The problem with this measure that I created is that it is not supposed to be summed. The thing is that I can't turn the totals off since there are other columns in the table that are supposed to have a total. I just changed color with conditional formatting.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

The condition in the measure checks if it is in the total row or not. And total has the different condition than each category.

background color condition: =
SWITCH (
    TRUE (),
    ISINSCOPE ( data[category] ),
        SWITCH (
            TRUE (),
            [Sales amount:] >= 5, "Green",
            [Sales amount:] >= 2, "Yellow",
            "Red"
        ),
    SWITCH (
        TRUE (),
        [Sales amount:] >= 20, "Green",
        [Sales amount:] >= 10, "Yellow",
        "Red"
    )
)

[FotFly]

Thank you for your answer. I was refering to this functionality under visualization and not the cell elements.

I was hoping I could avoid some extra work creating a measure to distinguish between total and other values to add background or font color under "Cell elements".