Forum Discussion

MarleeBI's avatar
MarleeBI
Regular Visitor
2 years ago
Solved

Format Painter for Field Columns - Is that possible?

Hello PBI Experts,   I have a PBI Table with 20+ field Columns (see below for screenshot). I have applied successfully of - Conditional Formating on 1 of the Column However, I would like to apply...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MarleeBI ,

    First of all, many thanks to  for your very quick and effective replies.

    Based on the knowledge, it is impossible to apply conditional formatting to all columns directly, you should apply formatting individually for each column.

    Please try the following methods as workaround:

    1.Create the simple table.

    2.Select the conditional formatting for 12 column.

    3.Select the Rules in the Format style and set the Rules.

    Besides, it is also able to create a measure for the column conditional formatting.

    Conditional formatting = 
    var colum_ = SELECTEDVALUE('Table'[13])
    RETURN
    IF(colum_ > 13 && colum_ <= 14, "yellow",
        IF(colum_ > 14 && colum_ <= 100, "green")
    )

    Select the Field value in the Format style for column 13 and choose the formatting measure in the field.

    You can also view the following documents to learn more about column conditional formatting.

    Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Wisdom Wu

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