Faheem (@FaheemH) from Denmark sent me this beautiful infographic depicting various facts about Immigrants in Denmark.
Immigrants in Denmark – Excel Infographic:
How is this Info-graphic made?
Faheem used a variety of tricks to create this infographic. Some of the key ideas are,
- Using text boxes and drawing shapes
- Using bar charts (with both negative and positive values)
- Using images (the stick figure charts are actually images)
- Using text, fill color and borders effectively to create the canvas
Download the Source File
Click here to download the source file of this infographic and play with it.
Thank you Faheem
Thank you so much for sharing your awesome work with all of us Faheem. You are a true champ. 🙂
Send your tips / downloads for Reader Awesomeness Week:
You too can participate and share what you know by simply filling up online form. Go on, be awesome. (details here)
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.