topic Re: How to highlight last column charts in DAX Commands and Tips

How to highlight last column charts

PouxieDouxie — Fri, 21 Jul 2023 18:08:55 GMT

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),

)

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.

Re: How to highlight last column charts

AlanFredes — Fri, 21 Jul 2023 20:21:49 GMT

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!

Re: How to highlight last column charts

PouxieDouxie — Mon, 24 Jul 2023 11:54:02 GMT

Thank you very much for your quick reply and solution