Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JuliaYebra
Helper III
Helper III

Is 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?

1 ACCEPTED SOLUTION

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/



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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.You can change the color saturation to highlight the bar in the different color.

Greg_Deckler
Community Champion
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?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_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?

 

DateToHighlight.png

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler Yes, I could do that but I'm trying to do it automatically as month changes and as new months are added.

Is it possible? I think this highlight functionality is not available.

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/



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors