cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JuliaYebra Member
Member

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

Accepted Solutions
Super User
Super User

Re: Is it possible to highlight some dates on a visual?

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/


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

Proud to be a Datanaut!


6 REPLIES 6
Super User
Super User

Re: Is it possible to highlight some dates on a visual?

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?


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

Proud to be a Datanaut!


JuliaYebra Member
Member

Re: Is it possible to highlight some dates on a visual?

@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

Super User
Super User

Re: Is it possible to highlight some dates on a visual?

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.


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

Proud to be a Datanaut!


JuliaYebra Member
Member

Re: Is it possible to highlight some dates on a visual?

@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.

Super User
Super User

Re: Is it possible to highlight some dates on a visual?

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/


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

Proud to be a Datanaut!


Anonymous
Not applicable

Re: Is it possible to highlight some dates on a visual?

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.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 106 members 1,578 guests
Please welcome our newest community members: