Forum Discussion
Column chart with conditional formatting and positive or negative deviation at the top of the column
Hi Maku12
you can check this video which is similar to your problem statement: https://youtu.be/wDNxTwiPg8k?si=euP-d5vbJ-CujL78
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more interesting solution here: www.youtube.com/@Howtosolveprobem
RegardsHi qqqqqwwwweeerrr,
thanks for solution proposal! Unfortunately the line for Sales of the Previous Year ia not shown, although I have selected it.Hi qqqqqwwwweeerrr , I seleced the Net Product Sales of 2022 in the filter for line Y-axis, which is a calculated measure that shows the Sales Amount of 2022, but nothing changed in the graph.
BR
Solution SageHi Maku12
Line is something not an issue try to create, and use required files in the line filed
for pervious year i am not sure what eactly the objective is can you please explain? Do you mean in filter if you select 2024 in filter your x-axis should be display month=year for 2023 or soemthing else?
Regards
Hi qqqqqwwwweeerrr , I seleced the Net Product Sales of 2022 in the filter for line Y-axis, which is a calculated measure that shows the Sales Amount of 2022, but nothing changed in the graph.
BR