Power Bi, Y axis, Values Fix after applying month filter

[Usman9022]

I want to fix my Y-axis values. They change when I apply a month filter. I have tried a solution, but it didn't work. I have attached the S.shot. 

[Usman9022]

Exactly This! Thank you Jai!

[Bibiano_Geraldo]

Hi @Usman9022 ,

Can you give us more details of what is needed to fix? if possible, you can show us the expected output.

[Usman9022]

@Bibiano_Geraldo @Laxmanjatoth @Jai-Rathinavel @ribisht17 .  Thank you everyone. 

Actually, I don't want  sequence of my titles (Home & life, sports and travel) to change when I apply month filter becoz at X axis my range is already defined and it does not change with month. But the bars position for each month (sports, home) gets changed.  for isntance IF i slect feb.. the top bar will be home and life style... if I slect march the top bar will be food and beverage. it sould remain at the permanent position... only their lenght should change as per the data....

 I hope this makes sense now.. 

[Jai-Rathinavel · Accepted solution]

@Usman9022 You have to then use the sort option and sort it by Niche field either by ascending or descending like below. This will not jumble the values and only the length of the bar will be changing

Did I answer your question? If yes, please mark my post as a solution.

Thanks,

Jai

[Laxmanjatoth]

Hey, dude

I read your post and was a little confused on what you meant by "fix the value." Could you maybe clarify? The y-axis will change depending on the filter which is month.

[Jai-Rathinavel]

@Usman9022 Is this what you are looking for ?

[ribisht17]

hi @Usman9022 

May I know, what do you mean by "FIX" since it will/should change as the profit will vary every month ?

Regards,

Ritesh