March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi ,
I want below color formating on rows .I want either font or background color according to status value.I m not able to achieve this any help please.
Thanks
Solved! Go to Solution.
@TomMartens Thanks for replying
I have used below approach.
I have created Color Table with Color Id and Color Name Columns
Hey,
this is my table
using conditional formatting on column this ...
... like so ...
... creates this output (i already did the same for the column that) ...
Important: you have to use a Power BI Desktop version that supports Conditional Formatting by "Field value", this feature has been introduced in Power BI Desktop with the August 2018 release, as I'm using the October release - it's there. You may have to consider to upgrade your current Power BI Desktop version if your version does not this option.
This blog post by Chris Webb lists the supported color names: https://blog.crossjoin.co.uk/2018/08/10/colour-names-supported-in-power-bi-conditional-formatting/
Please be aware, that there is a little glitch (but does not have any effect on functionality) within the dialog of the Conditional Formatting, but this will be fixed soon. Whenever you make the setting for the Conditional Formatting the dialog will look similar to this:
Hopefully this is what you are looking for!
Regards,
Tom
@TomMartens Thanks for replying
I have used below approach.
I have created Color Table with Color Id and Color Name Columns
I found that cross filter direction needs to be 'both' in the relationship if using the original Color ID in visuals.
I belive we have to do this for each column in table.
Is there anyway to do the Conditional Background Color for whole row and not individual column?
This solution doesn't work.... Or there's some step missing....
this solution doesn't work
Hi @atul9063
Glad to hear you've solved it, please accept your solution, that way, other community members will easily find the solution when they get same issue.
Regards,
Cherie
Currently there is no cappibility for custom formatting text, but you could create a custom column which inserts a number for each color. Then you can create a custom formatting rule using your custom column.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |