Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date (Year & Quarter) Sorting in a Graph

Hi All   I've got a supply and demand graph. Numbers wise my supply is a positive number and demand is a negative. The source is an excel spreadsheet. One of my columns is a text field which has fo...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    System Undersatnd ordering based on String data type because it's look like there are no seperate columns for year and It's Quarters. 
    Easy way to do it by creat indexing for Year/Qn column. and set created index column as order referance for Yr/Q column.
    Check this: https://www.youtube.com/watch?v=4xapOrfLvbg

    Keep Going 
    Best Regards,
    Nirav

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , this format itself is sortable.  On the three dot. Choose qtr year as the sort column. If this does not work

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Also refer how to use sort column - https://www.youtube.com/watch?v=KK1zu4MBb-c