Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, just a quick question - I already know how to apply conditional formatting (in this case background coloring based on rules), but I'm looking to highlight all fields in a row. There's a lot of fields.
Do I really need to apply it field-by-field? If so, is there at least some way to copy conditional formatting rules (similar to format painter), or do I need to do the same "change style to rule, change base field, change values, change color via hex code" 10 different times?
Hi, @RMDNA
According to your description, you would like to find a feature in PowerBI similar to the formatting brush in Excel for easy formatting, unfortunately, as of the current version, Power BI does not have a feature similar to the Excel formatting brush. You can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
However, you can try the following workaround:
1.DAX Metrics, If you use DAX metrics for conditional formatting, you can create a metric and reference it in the conditional formatting dialog box for each field. This way, you only need to adjust the metric if the rule needs to be changed, and it will be reflected in all fields that use the metric.
Tips for speeding up the process:
2.Templates, If you frequently use the same conditional formatting rules, consider creating Power BI templates. Once you have set up your report with all the formatting, you can save it as a template and then use this template to launch a new report with the existing formatting.
3.Power BI Template (.pbit), If you are launching a new report, you can save time by using a saved template with conditional formatting already applied.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hello @RMDNA ,
you can do it in a formula and then reference the formula in the conditional formatting.
check it out https://youtu.be/K-uhWhl9Grs?si=DzfK0Xw-hSitslKz
Proud to be a Super User! | |
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |