Forum Discussion
Dynamic Y range visual calculation in two level hierarchy
Hi somogyitamas88 ,
Could you kindly provide a small sample of your data, ensuring that it contains only the date, Sales, and Sales Plan fields, with no sensitive information included.
Additionally, please specify the Y axis values you would like to see at both the month and week levels so I can accurately align the solution to your requirements.
Thank you.
Hi, This evaluate Y Max as the max of total sales/total plans. So its do that I'd like.
Hi somogyitamas88 ,
You’re right about the issue. The chart is using total values instead of the highest value among the visible bars, so when you drill down to weeks, the Y-axis is still based on larger totals and doesn’t scale correctly.
In the shared .pbix, I fixed this by making the Y-axis look at the maximum value across the currently visible Month/Week level, comparing Sales and Sales Plan for each point. This way, the axis adjusts properly, showing the correct max at month level and switching to the correct max at week level when you drill down.
Thank you.
Unfortunately this is not a proper solution. Y max value is 330 whether we are on month or week level, which is the 1.1 times value of max weekly data.
Hi somogyitamas88 ,
Thank you for highlighting this issue. The behavior you're observing occurs because the current method evaluates data at the weekly level, even when the visual displays months. As a result, the Y axis continues to use the weekly maximum and doesn't adjust when navigating up the hierarchy.To address this, the calculation should align with the level shown in the chart. At the month level, the Y axis should reflect the highest monthly total, and when drilling down, it should switch to the highest weekly value. In the updated version, I have revised the logic so it now adapts to the current drill state of the visual, ensuring the Y axis scales appropriately at each level.
Thank you.
Hi somogyitamas88 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.