Y-axis value lower then column in line and stacked column chart

[Remon1991]

Hello everybody,

Im trying to fix the value that is show in y-axis of an line and stacked column chart.

The highest value is 46, but the y-axis only show 40 instead 50 what.

I have create this measure, it works but only gives me the highest value. Not the highest value of the total sum.

Last 13 weeks y-axis ongeplande uren Hector =

CALCULATE(

    ROUNDUP(

    SUMX(

        TOPN(1,

            FILTER(

            'OEE (y-axis)',

            [Date]>='Date'[Laatste 13 weken]

            &&[Date]<='Date'[Laatste week]

            &&[Lijn]=("Hector")

            &&[Category]=("Ongepland")

    ),'OEE (y-axis)'[Uren],DESC),'OEE (y-axis)'[Uren])

    ,-1)

)

The data in the table is this:

It gives me the highest value that is 35 and roundup to 40. The total is 49 instead of 46 because, i roundup the values in this table.

How can i adjust the measure, so it wil give me 50?

Kind regard,

Rémon

[v-sgandrathi]

Hi @Remon1991,

You need a measure that calculates the total hours (Uren) per activity, identifies the maximum value within the filter context, and rounds it up to the nearest multiple of 10 (e.g., 26.2 → 30, 46 → 50).

Try this DAX measure:

daxCopyEditY Axis Max for Hector = 
VAR TablePerActivity =
    SUMMARIZE(
        FILTER(
            'OEE (y axis)',
            [Date] >= 'Date'[Laatste 13 weken] &&
            [Date] <= 'Date'[Laatste week] &&
            [Lijn] = "Hector" &&
            [Category] = "Ongepland"
        ),
        'OEE (y axis)'[Activity],        
        "TotalUren", SUM('OEE (y axis)'[Uren])
    )
VAR MaxTotal = MAXX(TablePerActivity, [TotalUren])
RETURN CEILING(MaxTotal, 10)

Please add this measure to your model.

In the Y-axis settings of your combo chart enable “Show secondary” if necessary and use this measure as the Max value for both primary and secondary axes.

This will ensure that the top boundary of the Y-axis is always slightly above your largest column, rounded up neatly achieving the desired result.

I hope this helped! Feel free to ask any further questions. If this resolved your issue, please mark it as "Accept as Solution" and give us Kudos to assist others.

Thank you.

[v-sgandrathi]

Hi @Remon1991 ,

To ensure your Y-axis shows a rounded total (like 50 for a sum of 46), modify your measure to calculate the total sum instead of the highest single value, then round it up.
Here’s an updated version:

Y-Axis Max Value =
CEILING(
CALCULATE(
SUM('OEE (y-axis)'[Uren]),
FILTER(
'OEE (y-axis]',
[Date] >= 'Date'[Laatste 13 weken] &&
[Date] <= 'Date'[Laatste week] &&
[Lijn] = "Hector" &&
[Category] = "Ongepland"
)
),
10)

Use this measure to set the Y-axis max in the chart. This will ensure the axis accommodates the total values as expected.

Happy to help! If this addressed your concern, marking it as "Accepted Solution" and giving us "kudos" would be valuable for others in the community.

Thank you.

[Remon1991]

Hello @v-sgandrathi ,

Thank you for helping me. Unfortunetly i don't get the result that i want.

I used the measure below, and under that the diagram with the data and next to is a table with the outcomst of the measure.

It sums effery value and therefore the outcomst is 290. But i only need the highest value.

I dont understand why it said 40 by activity 360 camera, because in the diagram you can see the value is 26,2 and you want to get 30 as a result.

Last 13 weeks y-axis storing uren Hector =

CEILING(

    CALCULATE(

        SUM('OEE (y-axis)'[Uren]),

            FILTER(

            'OEE (y-axis)',

            [Date]>='Date'[Laatste 13 weken]

            &&[Date]<='Date'[Laatste week]

            &&[Lijn]=("Hector")

            &&([Category]="Ongepland")

        )

    ),

10)

[v-sgandrathi]

Hi @Remon1991 ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @Remon1991 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-sgandrathi]

Hi @Remon1991,

Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

[Remon1991]

Anybody else has an solution for this? I doesn't sound like a difficult problem i think?

[bhanu_gautam]

@Remon1991 , Try using

DAX
Last 4 weeks y-axis ongeplande uren Hector =
CALCULATE(
CEILING(
SUMX(
TOPN(1,
FILTER(
'OEE (y-axis)',
[Date]>='Date'[Laatste 4 weken]
&& [Date]<='Date'[Laatste week]
&& [Lijn]=("Hector")
&& [Category]=("Ongepland")
), 'OEE (y-axis)'[Uren], DESC), 'OEE (y-axis)'[Uren]
),
10)
)

[Remon1991]

@bhanu_gautam 

Unfortunately i get the same output compared to roundup.