Forum Discussion
JuliaYebra
Helper III
Helper IIIIs it possible to highlight some dates on a visual?
I need to show the evolution of the sales and to highlight some important dates to see how they behave around them. Is it possible?
Again, technically yes, it does exist. It is the conditional formatting feature, but it only exists for Tables.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/
Hi
You can make use of a Calculated Measure(flag) to identify the event or dates like below.
Color = IF ( Max(Calender[Date]) = MAX(Events[Event]),1,0)
I am checking if my calendar day on axis is equal to my event date, if yes then 1 else 0.
I used this calculated measure in color saturation field, and I was able to format the bar in the chart dynamically using calculated measure.\measure.jpeg)
You can change the color saturation to highlight the bar in the different color.