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

Hi v-easonf-msft 

 

I tried to upload the file for you but its not allowing me.

I tried your new measure but same issue... i am not sure where it is taking this average from because i need the average of the 2 totals (0 and 23)

 

 

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

Hi， Freeseman 

If possible, upload a sample file to cloud storage and share the link here.

 

Best Regards,
Community Support Team _ Eason

 

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

    Hi v-easonf-msft , Struggle with company procedure.

     

    Does this help

    I have time stamps but the average is calculated per row and not per category?

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

    Hi， Freeseman 

    Sorry for later reply. The link seems to have expired, can you share it again?

    Best Regards,
    Community Support Team _ Eason