Align close by columns when there are slicers

[rokas147]

Hi all,

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?

thanks

[Jihwan_Kim]

Hi, @rokas147 

Please correct me if I wrongly understood your question.

How about trying to create a Calculation Group by using Tabular Editor In Power BI?

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[rokas147]

Hi, what would be the point of that? I have never heard of that before and googling just gives broad explanations

[rokas147]

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