Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 the same Color Formating to - Rest of the other 20+ field Columns. Is that possible within PBI?
I know Format Painter works across two different visuals, but how does within same visual - different field Column work?
Thank you for your help in advance! Have a beautiful rest of your day 👍
Solved! Go to Solution.
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.
Hi @MarleeBI
Conditional formatting is applied one field/column at a time. You may raise this is an idea - https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=conditinoal%20formatting%20format%20painter...
Looking at the screenshot, it seems that you'll benefit from unpivoting your columns.
Proud to be a Super User!
You mentioned - "Conditional formatting is applied one field/column at a time"
If you don't mind, could you provide some more - step-by-step guidence - on how to apply it?
From the screenshot, How Can I apply Column 12 Color formatting logic - onto Column 13?
What I meant was you would have to open the conditional formatting dialogue box for each column/field/measure that you wanted it to be applied to - so for 20 columns that meant doing it 20 times. There is no option to select multiple fields and apply the same conditional formatting like you can in Excel.
XMLA endpoint is available only to workspaces with premium capacity enabled. And while you can use XMLA to change column formatting (like changing the data format), it cannot be used to apply conditional formatting.
Proud to be a Super User!
Perhaps - there's XMLA backend code - that can help me apply Column 12 conditional formating - to all my other columns - Column 10-30??
That would be very helpful. But I do not know how to do so in XMLA nor Formating Painter...
Anyone could help?
Hi @MarleeBI
You cannot use XMLA endpoint to conditionally format columns. Also, once a change is made to a Power BI semantic model through the XMLA endpoint, it's not possible to download the model as a .pbix file from the Power BI service.
If your table is how it is shown on the screenshot from @v-jiewu-msft , I would suggest you look into unpivoting the number columns so conditional formatting is done to just a column. After unpivoting, those number columns become two - one for attribute containing the columns and another one for value containing the values of the original columns. Your table would look something like below.
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |