Date Sort

[Anonymous]

I have a month that is a text column.  I created a date table and linked them together with the month number but the sort isn't working in chronological order.  I've literally been working on this for 3 days.  😞  What am I doing wrong?  I'm new to Power BI so I'm obviously missing something.  I've been watching videos and reading till my eyes are shot.

Any help would be greatly appreciated.  

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to my understanding , there's a relationship between two tables based on Month and you want to sort Month in Table1 by Month Number in Table2 ,right?

You could create visuals with Month in Table1 and Month Number in Table2 since the relationship has been established between the two tables. And then sort by Month Number ascending.

Or you could use LOOKUPVALUE() to add a new column and then sort ascending like this:

Month Number =
LOOKUPVALUE ( 'Table2'[Month Number], 'Table2'[Month], 'Table1'[Month] )

Here is the pbix file.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to my understanding , there's a relationship between two tables based on Month and you want to sort Month in Table1 by Month Number in Table2 ,right?

You could create visuals with Month in Table1 and Month Number in Table2 since the relationship has been established between the two tables. And then sort by Month Number ascending.

Or you could use LOOKUPVALUE() to add a new column and then sort ascending like this:

Month Number =
LOOKUPVALUE ( 'Table2'[Month Number], 'Table2'[Month], 'Table1'[Month] )

Here is the pbix file.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Eyelyn Qin

[Anonymous]

Thanks so much!  I appreciate all the help and the files you provided.  It was very helpful.  Now that part is working, I have another issue. 🙂  It's a very weird one to me.  I have a row title that's not showing until I add another row to it.  It should be showing the title "Diagnostic Procedures".  If you see in the first pic, it's not there, but as soon as I add another row it appears.  The "ADP" isn't supposed to be there, I just added it to demonstrate the issue I'm having.  If I remove "ADP" from the value, the "Diagnostic Procedures" disappears.  I hope that makes sense. Any ideas?

[Anonymous · Accepted solution]

Hi @Anonymous ,

To my knowledge, it's by design.  When more than one field is placed in Value fied, the title will be displayed in order to let users know each value more clearly. There is no such misunderstanding/confusion when there is only one value. 

In addition, I suggest you creata a new post to get more engineer involved since the original issue has been solved. Thank you ~

Best Regards,
Eyelyn Qin

[Anonymous]

That makes sense.  I don't like it, but it makes sense. 🙂   Thanks!

[blopez11]

In this view, data view of your tables, the sort doesn't apply

Sorting is by data type

The "sort by" is applied to visuals

[Anonymous]

Yes, but the visual looks that way too.  It's not sorting chronologically.