- Stop doing what you are and go read Unleashing the Ideavirus by Seth Godin. Even if you have already read it, do it again. It helps keeping your mind alive.
- My plans to start Calvin Fund are slightly delayed, thanks to my forgetful finger, I lost my login password at the trading site and would take a while before I have it up again. Meanwhile, market seems to have done one full circle, whatever 😉
Saw this (look right) when I went to Landmark Bookstore few days ago. Now tell me, how many of you have actually played “Ashta Chamma”, “Puli-Meka” “Daadi” when you were kids? I am not sure what you might have called them, but these games exist pretty much in every state. Good to find that someone is selling them neatly packed in toys section of a leading bookstore.- If you ever happen to be Chennai during the summer time and have really nothing to do, dont even think of going to Marina beach. We did that last weekend and I still feel itchy, dirty, sweaty and angry inside for doing that.
- We are off to Vizag for a few days, to our in-laws place. I would resume regular broadcast on PHD only on 10th April.
Mandatory Trainings: Are we doing them? [Data Analysis Challenge – 002]
This week, let’s try something new. I have a spreadsheet challenge for you. Solve it, post your answers by leaving a comment. No cheating or
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.