Forum Discussion
Table view showing last sales date
Hi,
We have a dashboard for monitoring the sales, we would like to add a table visual which will show salesman, sales figure and date of last sale only . If last sale date is more than 10 days ago it should be highlighted. Request your guidance to make it happen
regards,
dsmitha
Hi Anonymous ,
For this you need to add a measure with similar to this:
Last Sales Highlight = IF( MAX(Table[Last Sales Date]) < Today() -10, 1)Then on then on the condittional formatting select this metric has the value and with rules if the value equals 1 then select the highlight colour you want. Be aware that being a table you need to add the condititonal formatting to all the columns you have on the table.
2 Replies
- MFelix
Super User
Hi Anonymous ,
For this you need to add a measure with similar to this:
Last Sales Highlight = IF( MAX(Table[Last Sales Date]) < Today() -10, 1)Then on then on the condittional formatting select this metric has the value and with rules if the value equals 1 then select the highlight colour you want. Be aware that being a table you need to add the condititonal formatting to all the columns you have on the table.