Log In
Register
Home
Active Member
June 15, 2021
Offline
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?
See Answer
July 16, 2010
Online
Hi Shashank,
Chart's cannot display conditional formatting or detect conditional formats in cells in order to display them. You would have to use a formula that returns a value that can be displayed in the chart, either in the data labels or series names.
Mynda
Active Member
June 15, 2021
Offline
In that case, if I have store name column and corresponding sales values ranging from 100 to 1000 and I want to highlight only those sales whose sales is less than 300 on a dashboard. How should i approach?
July 16, 2010
Online
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
Offline
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)
