Forum Discussion
Sort month on visuals using month no. column
Hi,
I am having difficultly sorting all visual in a report with the same month no. column. Has worked previously without any issues but after the May 2018 update I seem to be having issues.
I have created a simple sample pbix file however do not know how to add to post. Any Idea how?
Cheers
Elizabeth
5 Replies
There is no general issue in the May release. The main thing is that there must be a one to one match between the numbers in the integer column and the text in the tex column. Eg each 1 must map to Jan, and each Jan must map to 1, etc
You can check by creating A ne stable with the new table button and typing =ALL(calendar[month num],calendar[month name])
you will then see if there are any issues.
Hi Matt,
Thank you for helping me work through issue.
I already have a a month no and month name in the current date table. Why am I introducing a new table with the same information.
Cheers
Elizabeth
Hi Matt,
How do I map the two columns in Desktop.
I have have attached some photos because not sure how to send pbix file.
Cheers
Elizabeth
Hi Matt,
Here are a few pictures. How do I map the two columns, Monthno and MonthName
Are the "month.no" and "month.name" columns calculated columns or original columns from data source?
It seems weird because they don't match with each other.
How to share your pvbix?
upload your file to OneDrive for Bussiness->right-click on this file-> select "share"-> copy the link->paste the copied link to the "insert link" when replying.
Best Regards
Maggie
