Here is a quick visualization challenge for you.
There are 25 KPIs and each has a base value, current month, corresponding month values. The KPIs also have targets.
The data looks like this:
Download the data:
Click here to download the data for this contest.
Rules for this contest:
- Visualize this data using one Excel chart (one chart per KPI is ok too).
- You may omit any data
- You can use interactive charts.
- Do not use add-ins or VBA to make your charts
Go ahead and make your chart(s).
Last date & how to submit:
- Last date for this contest is 1st November, 2015 (Sunday).
- Once your chart is ready, email the workbook to chandoo.d@gmail.com with the subject “KPI contest“
- Winners will be announced in 2nd week of November, 2015.
What do winners get?
After carefully reviewing all the charts, 2 winners will be selected by our panel of judges. Each of them will get $100 Amazon gift card.
So what are you waiting for. Go ahead and visualize the data and show us how awesome you are.
Thanks to shaikhrulez @ Chandoo.org forum
Thanks to shaikhrulez at Chandoo.org forum for the data & question that became this contest.
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.