How to highlight last column charts

[PouxieDouxie]

Hello,

I am an intermediate in PowerBi and I need your help.

I am trying to get my last columns highlighted as you can see below based on current or latest month.

I found this DAX formula but it is only working when you have a single column.

Is last Period =

VAR CurrentPeriod = MAX(DIM_Calendar[Month_Year])

RETURN

IF(

    DATE(YEAR(CurrentPeriod),MONTH(CurrentPeriod),1) = DATE(YEAR(TODAY()),MONTH(TODAY()),1),

    1,

    0

)

this is my current view

This is what I would like to get. (this screenshot was manually done)

Many thanks in advance for your help. Don't hesitate if you need more details.

[AlanFredes · Accepted solution]

Hi,

Adding conditional formating is only available when you have one series in the Column chart. If you want to custom format the Column Chart with multiple series/column you will need to use a Customizable Visualization such as Deneb (https://deneb-viz.github.io/).

This video might help you: https://www.youtube.com/watch?v=hE8R06PI0g4

Did I answer your question? Mark my post as a solution!

[PouxieDouxie]

Thank you very much for your quick reply and solution