Add indicators in Bar Chart

[Anonymous]

I have a bar chart with X-axis in daily buckets and volume on Y -axis. I have a conditonal formatting which says - If my volume is greater than yesterday, color the bar red else Green. I am looking an additonal way to highlight weekends.  I tried to add some kind of icons to the chart but I was not able to do it . What would be a better way to highlight weekends in this case where I already have a conditonal format applied for a different logic?

In my data source I have a column to identify day number For e.g. Sunday is 1 and Saturday is 7. Any inputs will be helpful. Thanks in advance. 

Let me know if any further information will help address the query. 

[amitchandak]

@Anonymous , if you are not using legend,

You can create color measure and use it. example

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Anonymous]

Amit,

Thanks. A variation in dark and light colours kind of worked out as a solution. 

Regards,

GB

[AllisonKennedy]

You could create a measure that will determine if it's a weekend first and apply desired colour, then check for is greater than previous day and apply next colour. If you need help with this exact calculation, please provide column and table names for your existing data and explain how you have done current colour coding (are you already using a measure?)

[Anonymous]

Allison,

Thanks a lot for your quick response. 

I have already created a quick measure which says if my volume today is greater than previous day then 1 else 0. Based on this measure I have applied the below conditional formatting. 

Now while the bar colors will be either Green or Red based on above condition I somehow want to highlight weekends to stand out so I can easily identify which bars belong to weekends.  For this as a first step I created a column called Day_Number where Sunday is marked 1 (First day of the week) and Saturday 7 and so on. I tried to do something based on this but I am stuck at this point as I cannot apply multiple conditional formatting on a single quantity. Is there any other way or any other chart options ? 

Thanks in advance !

[AllisonKennedy · Accepted solution]

What colour do you want weekends?

You just need to continue to refine your existing measure, and create four values:

If weekend and greater than previous day, then 1,
If weekend and less than previous day then 2,
If weekday and greater than previous day then 3,
If weekday and less than previous day then 4.

Then conditional format with light green, green, light red, red, or whatever colours you'd like.

[Anonymous]

Allison,

Thank you . This worked out well as a solution. 

Regards,

GB