I have this problem. Picture attached below. The left and right columns are from differenct calculations impacted by various slicers, if I leave y axis on auto for start and end, it seems like that 0.4m is bigger than 1.5m which makes no sense.
If I set up start and the end values for y axis, after the different values affecting the columns have been imputed in the slicers, it could provide values 0.2 and 2.5m for example. Thus, start and end values simply dont work as I want to leave the flexibility.
How can I solve this problem and be consistent and have my graphs looking nice?
At this point in time ive worked for over 100 hours on this power bi creating 20 sheets, so redoing everything on a new platform per se does not seem like a solution.
I imagined there could be some sort of easier way of solving this.
I was thinking of taking the max value of the bigger column - largest value of the smaller column and add it to smaller column. In this case, i have same y axis but additional part of the column, even if i make it white, it covers the gridlines and has the value, thus, does not seem to be a solution