It is Easter Time again. Although I am not in Scandinavia (where Easter is a big thing) any more, we have a rather biggish family gathering here at PHD household during this weekend. We are also having anna prashanam for the little ones. It is the ceremony we do in India when kids eat rice for first time. [more about Anna Prashanam rituals on Wikipedia]
So, as you can imagine, PHDs will be busy during the weekend and on Monday as well. But we don’t want a dull Easter for you. So I have hidden 3 Easter eggs in this post. Go ahead and discover them to enjoy your Easter.
Easter Egg photo from tillwe.
PS: You may not find the eggs if you read this post in email or feed reader. Just come to my blog and see it. Click here.
PPS: Check out last year’s Easter Egg post to get some inspiration.
PPPS: Have a blasting weekend. See you on Tuesday with more excel stuff!
2 Responses to “Top 10 Power BI Interview Questions & Answers”
Hello...
In Power BI I have data that includes months by name only (e.g. May, April, December...)
I need to build charts etc. but i need the months to go chronologically... not alphabetically... I cannot seem to find the fix to this.... once again, my data does NOT have an actual date attached to it (like 02/01/2023)....only month names... can i use a helper table wher i id the month names as numbers 1 thru 12? and if so, how do i manage this to work for me ?
Thank you.
~Keith
You need to setup an extra table to map each month name to a running number. A simple 12 row table like
Jan 1
Feb 2
Mar 3
..
Dec 12
Then create a relationship between this month table and your month column
Now, go to "table view" in Power BI and set the sort by column to month number for the month name column on this new table.
Finally, use the new table's month name whenever you need to refer to the month name in the visuals.
They will be chronologically arranged.