Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Report does not look like the raw data field....

My report looks like this...       Day 1                                                                  Day 10                                                                  Day 11            ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    How did your records store? Did these stored in different fields or they are in the same field and use whitespace to define the hierarchy level? If this is a case, you can split by the delimiter and sort by different hierarchy fields on the query editor side.
    Regards,

    Xiaoxin Sheng

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

you need to add a new column with the desired sort order (for example an index column).  Then in Power BI you can use the "sort by another column"  function.