Forum Discussion

Haider121's avatar
Haider121
Frequent Visitor
9 years ago
Solved

Sort a column chart by x axis data category

I have data like this  <10 10+ 50+ 75+ 100+ Not at Customer DateKey InsertTimestamp 789 1303 458 242 98 2441 20170111 2017-01-11 10:07:11.620 742 1492 658 328 139 2560 20161228 2016-12-28 00:00:00.0...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Haider121,

     

    If you use the live mode to connect, you can only group rank at service side.

    If you use the import mode, you can refer to below link which about group ranking:

    Raking within a group

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Haider121 It sounds like Grouping/binning might be your solution. Take a look here

Haider121's avatar
Haider121
Frequent Visitor
9 years ago

Sorry I forgot to say my data is coming froma SSAS tabular model so its not a dataset within powerBI that can be grouped or binned.

 

That option does not appear when selecting the columns for me.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Haider121 do you work in the Channel Islands?

    • Haider121's avatar
      Haider121
      Frequent Visitor
      9 years ago

      no I work near manchester

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Apologies...I thought you might have been an ex-work colleague with the surname Haider.