Forum Discussion
Format Painter for Field Columns - Is that possible?
- Anonymous2 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.
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.