How to add font color or background color

[rainchong7401]

Hi Friends,
How to add font color or background color for every last year.
Kindly assist. 

I've provide my file in the link down below.
https://www.dropbox.com/s/5mzjdamxicrs4ks/TEST--v2.pbix?dl=0

[SamInogic · Accepted solution]

Power BI allows Values to be formatted based on data, using Conditional formatting.

In your report, for Measure in the Values property set the Background Colour using Conditional Formatting as shown in the below screenshot.

Set the colour as per the condition required, on the Year column as shown in the below screenshot.

Thanks!

Inogic

Innovative Logic  

Web: www.inogic.com/services/

Blog: http://www.inogic.com/blog

twitter: @inogic

[rainchong7401]

Hi Sam,
You're very good. 
Your solution is straight forward and accurate result.

[PBI_Helpline]

Hi,
Based on your attached PBIX, where you have used only one measure but 2 column headers,  and below kind of formatting for 'HEADERS" are not available with specific column, because that will be enabled only if you have more than one measure.

Above is possible with specific column only if you use more than one measures.
 Since your Meassure is giving values for 2 consecutive years based on selected year in the slicer, it has only one measure, but two fields in Column header well,
and in this case you can use below conditional formatting measure to format values section of your Matrix visual.  it means, Headers can not be formatted with different colors, in this case., if required you can select one single column header color.

Thank You,
I post Interesting Power BI Solutions on below You-tube channel.
https://www.youtube.com/@PowerBIHelpline
Check this out.

[rainchong7401]

Hi PBI,
What about I want font color to change instead of Background? 

[PBI_Helpline]

Yes,
That can be applied on font color as well same way.

[rainchong7401]

Hi PBI,
Where do you put the format measure into and make it look colorful?
Kindly show me the location where do you put the "format" measure.
You may screenshot and show me step by step or,
If possible share your work via google drive or dropbox. 

This is mine looks ugly and it's not exactly like what you do.

[PBI_Helpline]

If you click on the small dropdown arrow on your measure name in values section. like below, you will see conditional formatting option for all the available formattings. Font, background, icons..

Click on Conditional Formatting > Font> in Format Type select "Field value> Apply to "values and Total" > and in measure section select the new Format measure, which you created for color formatting.


Thank You,
I post Interesting Power BI Solutions on below You-tube channel.
https://www.youtube.com/@PowerBIHelpline
Check this out.

[amitchandak]

@rainchong7401 , Create a measure and use in conditional formatting using field value option

bg color = If(Max(Table[Year]) = Maxx(allselected(Table), Table[Year]) -1, "Yellow", "White")

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[rainchong7401]

Hi Amit,
What about I want font color to change instead of Background?