It has been a while since I have proposed “tweetboards” an option for people making dashboards. I have received two very good examples of the dynamic (automatically updating) tweetboard implementations from our readers.
1. The first example from Fernando
I must appreciate Fernando for sending this beautifully implemented tweetboard. Not only that, he took great troubles to change the formulas so that the dashboard would work in my version of Excel (he prepared it in Portuguese version where the formulas are named differently, so when I open it in my comp, the formulas would show #NAME! error)
Thank you Fernando 🙂
Download the tweetboard implementation example 1 and see it yourself.
2. The second example from Lee
Lee has combined traditional dashboard charts with descriptive text message idea from tweetboard to create this neat claims dashboard. It is very well implemented.
Thank you Lee 🙂
Download the tweetboard implementation example 2 and see it for yourself.
If you want to share your tweetboard implementations
Please drop a comment or tweet me at @r1c1 or email me at chandooDOTd @ gmail.com
If you are wondering what the hell tweetboards are…
Read this post.
Also, read our 6 part tutorial on preparing KPI dashboards in Excel.
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.