Forum Discussion
Highlight bars in a combination chart (conditional formatting of bars)
I need to highlight the bar for the latest month with a deviating colour in a combination chart. Preferably not just the latest month but the value for that month in the past years of data being sho...
I was unable to highlight the bars in the combo-diagram, but I could conditionally format the Total-labels per bar.
SamWiseOwl
Super User
Super UserHi Anonymous ,
Create a measure similar to this but with your column names:
Colour Measure =
IF(
SELECTEDVALUE(Purchase[PurchaseDate].[Month]) = Format(TODAY(),"MMMM")
,"Yellow"
,"Teal"
)
SelectedValue lets you reference a single value in a column, in this case the name of the month column. Test that against this months value. Alternatively you could do FORMAT(MAX(Table[DateColumn]), "MMMM") to make it based on the highest value in your data.
Then go to your Columns settings and set Format Style to Field value and select this measure.
Then go to your Columns settings and set Format Style to Field value and select this measure.
If this helps please mark the answer as solved so others can find it.
Thanks SamWiseOwl, but is unfortunately not possible for me to choose to use a formula in the bar colour section, there is no such option:
- SamWiseOwl
Do you have something in the legend? Or two items in the column y-axis?
You can't have multiple series and conditional formatting.