how do i colored last month columns by default in clustered column ?

[Anonymous]

hi dears

i have a clustered column visual

i need to know how do i make the last month value to be colored with a different color than the previous months?

i.e. we are on ocotober so i need september to be colored with a different color so the one who is seeing the visual will be able to notice the last month value

you may refer to the below example

[SamWiseOwl · Accepted solution]

Create a measure to control the colours:
Colour Measure = If( month(lastdate(table[date column]) )= Month(today()) -1, "Green")

You could also use Calculate(Month(lastdate(table[date column]), all(table[date column)) instead of today()

Assign this measure to the column colour under Field value.

[Anonymous]

thank you for your response if could help me with the correct measure ( im new in powerbi )

im using ( month name ) for X axis the below is my visual

the below is my table

if you can write for me the correct measure i will be greatful 

[SamWiseOwl]

Hi @Anonymous 

Colour Measure = If( selectedvalue(Mail[Month])= Month(today()) -1, "Green")

[Anonymous]

god bless you sam

last question ..

how do i use this measure?  should i keep the measure in the tooltips of the visual which i want?

or should i keep it on a filter visual? 

[SamWiseOwl]

Hi @Anonymous 

You can assign this field to the column in your visual.

Select the column chart.

Go the the Visualisation pane and choose the paint brush icon.

Scroll to Column and expand to the Color setting.

Click the Fx symbol.

Change the drop down to Field Value.

Select the measure you created.

[Anonymous]

hi brother the measure showing error 

[SamWiseOwl]

Colour Measure = If( selectedvalue(Mail[Month])= Month(today()) -1, "Green")

There was an extra bracket after Mail[Month] try the above!