highlight offer sales period in column chart

[dsmitha]

Hi,

We have a dashboard in which a column chart is showing the sales, we would like to highlight the sales on offer days ( which is not a fixed one - it may be on sunday / monday .....or on weekends ), how can we make this happen . Request your guidance

regards,

dsmitha

[pratyashasamal · Accepted solution]

Hi @dsmitha ,
Create a column/measure using dax function where you simple assign 1 to the days with Sales/Offer and 0 to the days without. Then simply use this column/measure in conditional formating then with data rules.

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[dsmitha]

hi pratyashasamal,

Thank you very much for the cool idea, double kudoz

regards,

dsmitha