Forum Discussion

Freeseman's avatar
Freeseman
Icon for Helper II rankHelper 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
Freeseman's avatar
Freeseman
Icon for Helper II rankHelper II
4 years ago

v-easonf-msft 

 

This is extremely helpful.

 

I need the average of the SUM of production per group. I tried this:

 

NS Lunch = if(MAX('PRODUCTION'[TIMESTAMP (groups)])= "2. NS Lunch",CALCULATE(AVERAGE('PRODUCTION'[PRODUCTION]),FILTER(ALL('PRODUCTION'),'PRODUCTION'[TIMESTAMP (groups)]= "2. NS Lunch")))
 
My Average lines do not look good. I need to work something out.

 

Freeseman's avatar
Freeseman
Icon for Helper II rankHelper II
4 years ago

I think it has something to do with the way its grouping the times vs reading the production value?

Production is SUM over multiple timestamps because there are many production values from different machines in the hours. SO i need the sum of the total hour groups production which i believe is possible but the meassure needs to change calculation?

Its making all average line 97.xx

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi， Freeseman 

    Please convert the chart into a table visual, which will be easy to find the problem.

    Can you share a copy of the sample data?

     

    Best Regards,
    Community Support Team _ Eason

    • Freeseman's avatar
      Freeseman
      Icon for Helper II rankHelper II
      4 years ago

      Thank you.

      The data is a lot to share as i have many other tabes from other DB tables.

      The way you explain to me is very good and helps me a lot. I just need to fix meassure calculation?

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity 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