
Active Member

June 15, 2021

How to show conditional formatting icon on chart? for eg. if i have multiple entries for sales column for a series of date as 200,500,600,300,400 etc. Now I apply conditional formatting so 0-250:Red, 250-500:Yellow, >500:Green now I came up with the indicator column. No I want these indicators to reflect on chart if I select a particular date. Could you please help me?


July 16, 2010

Using a technique like this highlight min and max values in a chart. It obviously highlights the min and max, but you can change the formula to include sales <300.
Mynda

Answers Post

Power Query
Power Pivot
Power BI

October 17, 2018

In the past I've used threshold lines in my charts. One data series as a bar chart, and an additional series as a line chart. Usually that does enough to show where sales hasn't met the criteria.
Another possibility is to have additional series with if formulas that meet your needs. Then add those series to your chart with 100% overlap and changing the colors of those series.
1 Guest(s)
