I am working with a clustered bar chart where I ideally would like to have the value axis (X axis) going from left to right instead of right to left. The reason this happens is because I deal with negative numbers (accounting postings) which cannot be switched to positive.
Therefore, I am wondering if there is any way to flip the value axis so that the graph would look the same as if the values were positive (0 in the bottom left corner where -10M is and -10M in the bottom right corner where 0 is)? In other words, a flip of the graph along the vertical axis.
Due to the sensitivity of the PBI file I cannot share more than a snipshot of the graph…
I don’t know if you’re negative numbers are just a single column in your dataset or if they are all over the place, but if they are limited to a couple of columns or less, could you create calculated column(s) that contain the absolute values of the negative numbers, and then use that column for your chart(s)?
We are running a live connection to Analysis Services cubes so that would have to be done backend and not in PBI. But regardless, this is unfortunately not a feasible solution as it will create issues other places in the reports. As I wrote this are accounting values, hence credit postings as well which should be negative.
Hi @FredrikH, we’ve noticed that no response has been received from you since the 20th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!
