Forum Discussion
Power Bi, Y axis, Values Fix after applying month filter
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 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
7 Replies
Exactly This! Thank you Jai!
- Jai-Rathinavel
Super User
LaxmanjatothResolver I
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.
- 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.
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
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
