Forum Discussion
Column chart with conditional formatting and positive or negative deviation at the top of the column
I have created the following diagram in Excel: It shows the sales budget per month (gray columns) and the respective overrun or underrun of the actual sales figures per month in green or red within the budget columns. The values for budget and variance are also shown. The line corresponds to the previous year.
I tried to recreate it in Power BI and created the following diagram.
I need it to show the positive and negative variances at the top of the columns like in the Excel chart (green for positive deviation and red for negative). In addition, only the budget values and the variance values should be displayed (the small triangle is not necessary, the deviations can be shown as values).
I have tried to format the columns conditionally via the format area, but have not found a solution to my problem, because the positive and negative deviation is within one measure, furthermore I haven't found any possibilty to shift the axis so that both deviations are on top of the columns. In order to display the necessary values, I have tried to adjust the labels for the entire data.
When I select the labels for the entire data, only the sales budget and the variance to the sales budget are displayed. However, the problem is that the sales budget adds up with the variance if it is positive. However, I would like to see them displayed separately.
How can I format my columns as required and display the most important values?
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
7 Replies
_AAndradeResident Rockstar
Hi,
I've made a simple example, please check if this is what you're looking for:
If this solve your problem I can share with you the pbix file.
qqqqqwwwweeerrrSolution Sage
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.- qqqqqwwwweeerrr
Hi 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