Forum Discussion
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/
6 Replies
- Greg_Deckler
Community Champion
Not exactly certain of what you are trying to accomplish but I'll throw out some ideas. You can format tables based upon threshold values. You could also filter a visualization down to only certain dates based on some threshold value. If there is no threshold value, you could create another table and put the important dates in that table and do your filtering that way. Can you provide any additional information on what you are trying to accomplish?
JuliaYebraGreg_Deckler I'm trying something like I did in the following image.
I have a datasource with the revenue, profit, etc... and I would like to dynamically highlight in the same visual some dates in that period as you change the selected period. All the dates I want to highlight are already defined in other datasource.
Is it possible?
- Greg_Deckler
Ah, so technically "yes". What you would do is go to the format area of the bar chart (the paintbrush icon). You would expand "Data colors". You would then move the slider to "Show all" to "On". Then you go find your dates and change their colors.
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.
