Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
hi pratyashasamal,
Thank you very much for the cool idea, double kudoz
regards,
dsmitha
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |