Forum Discussion

Helper II

4 years ago

Shaping Dates into categories

Hi All, I am trying to structure my X axis by hour but in a specific order. So by default Power BI would arrange my hours from 0 - 23 or it would kind of just mix them up as below. The re...

Need Help

v-easonf-msft

Community Support

4 years ago

Hi, Freeseman

I suspect this has something to do with the date slicers.

Is 'Shift Date' a field in a separate calendar table?

Will the result of the current measure "Evening Shift Change" change with the value of slicer 'shift_date'?

After you clear the filter criteria for the date slicer, is the calculation result correct?

NS Lunch =
IF (
    MAX ( 'PRODUCTION'[TIMESTAMP (groups)] ) = "2. NS Lunch",
    CALCULATE (
        AVERAGE ( 'PRODUCTION'[PRODUCTION] ),
        FILTER (
            ALL ( 'PRODUCTION' ),
            'PRODUCTION'[TIMESTAMP (groups)] = "2. NS Lunch"
                && 'PRODUCTION'[Shift Date] IN VALUES ( 'PRODUCTION'[Shift Date] )
        )
    )
)

Best Regards,
Community Support Team _ Eason