We have been debating whether or not to buy iPhone. For one, we are not on any cellular contract and free to go. But the sheer cost of $400 one time (one for my wife and one of me) and a monthly bill of ~ $150 is holding us back. Our current mobile bill is roughly $80 per month and when we choose to go back home we can just takeout the SIM Cards and thrash it without having to bother about paying any contract breakage (incidentally for iPhone this could be as much as $175 per line). On the other hand, the iPhone is excellent value for money for the awesome features it provides. Our current phones were bought at Rs. 10,000 a piece (roughly $250), even though they were world class when we bought them 2 years back and still work well, their features are no where comparable to that of iPhone’s. Hmm…
Here are few excellent excel links from the last week around the web:
- Learn about excel category axis, find out how to use dates, numbers, text etc. on category axis for charts. See how you can tweak the axis to get the outcome you want (for ex: How to show weekdays on a date axis, how to configure axis for stock ticker charts etc.)
- If you are the kind who would install lots of add-ins to do your work, then you may be wondering how to find out what are the add-ins you have in place. Find out all the COM add-ins you have installed in Excel from Daily dose of Excel
- Winners of 2008 Excel Dashboard competition, see the beautiful and informative dashboards here 1, 2 and 3. The winner got an iPhone, alas, if only I knew about this earlier, I would have wondered “how to dashboard” instead of “to iPhone or not to iPhone”.
Got a hot excel tip to share, drop me an email or leave a comment.
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.