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

Anybody have ideas:)

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

Hi, Freeseman 

You need to enter a custom table and then sort Column ‘Category’ by Column 'Sort column'.

 

After you establish a relationship between the custom table and the fact table, you can replace the existing fields with the new fields like below:

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

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

      Hi, Freeseman 

      Try to use 'Line and clustered column chart' to replace 'clustered column chart' so that  you can add custom line chart as below:

      Average of Part1 = if(MAX('Fact Table'[Category (groups)])="Part1",CALCULATE(AVERAGE('Fact Table'[Value]),FILTER(ALL('Fact Table'),'Fact Table'[Category (groups)]="Part1")))
      Average of Part2 = if(MAX('Fact Table'[Category (groups)])="Part2",CALCULATE(AVERAGE('Fact Table'[Value]),FILTER(ALL('Fact Table'),'Fact Table'[Category (groups)]="Part2")))

      ......

       

      Best Regards,
      Community Support Team _ Eason

       

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

        Wow, i am amazed. 🙂 Thank you. Let me try this.