Workout 001 – Hotel Rating – bar chart and table
Difficulty rating: 2,5 out of 5
In this workout, using the supplied dataset we are going to replicate the following set of vizualizations (left section in a report screenshot), including a slicer, bar chart section and table section. Holistic solution requires to include each section listed above, but it’s also eligible to provide a solution that will only contain either the bar chart section or the table section. Also, please feel free to add any extra visual if needed (provided that core visualizations are included in the first place).
001 - Workout - Hotel rating (bar chart & table).xlsx (71.8 KB)
- Creating interactive set of vizualizations (verifying if data is presented correctly after using interactions / slicers)
- Presenting data in the top-bottom structure (overall metrics / details)
- Using supplemental visual elements (unicode symbols / icons)
- Writing basic dax formulas to achieve desired visual effects (grey bars in a bar chart, text box with names of selected items)
- Enhancing data story-telling by using the combination of chart(s) and table(s)
Please load the supplied data (xls file) into a new Power BI file, replicate visualizations, and reply to this post including the screenshot (or a gif) of your solution along with the pbix file.
This workout is released on Monday March 27, 2023, and the author’s solution will be posted on Monday April 3, 2023.
Link to the interactive dashboard:
@Gustaw is in the house! Superb workout, I can’t wait to get stuck in……shame I have a job otherwise I’d be starting it now!
“Exhilarating! Although it presented a challenge, I am grateful for the opportunity to expand my knowledge and skills. I eagerly anticipate the next challenge that comes my way.”
Mmmm, I got close I guess.
**Updated 28/03/23 -
as @Gustaw has said, lots of little design elements can add up to a great design…woke up this morning and realised how I had missed an element in the table.
By adding white lines, it separates out the grey background of the 2nd scale column to create/enhance the effect of a target data bar. Updated PBIX included also
Data Visualization Workout 001 - Ratings.pbix (88.4 KB)
Great workout - need some additional formatting and report title but here it is:
Rating_Example.pbix (44.2 KB)
Dear all, thanks for the nice challenge: On first glance it seemed easy, but some features did need some consulting of ChatGPT …
I added also two cards for the most and best rated hotels.
workout1_hotelRatings.pbix (751.3 KB)
Great first post on the forum @DianaAckermann
If someone need a native visuals for stars, you can check at:
@Gustaw - great workout!
I’ll preface this by saying I don’t have a lot of time this week but didn’t want to miss out. I didn’t try to hit the formatting, color scheme, or the full layout and rather just focused on capturing most of the elements (missed a few).
I think this is similar to skipping the one hour aerobics class and just hitting the treadmill for a few minutes.
Workout 001.pbix (70.7 KB)
Here is my Submission for Viz Workout001
VIZ_workout001.pbix (80.2 KB)
Workout 001 -Ratings.pbix (34.1 KB)
I like this workout. I am waiting for more …
Really enjoyed this one, learnt some visualisation and design tricks that will definitely be using going forward!
Data Visualization Workout 001 - Ratings.pbix (85.0 KB)
Absolutely bang on @jamie.bryan
@DavieJoe Your pbix helped a lot with the bits I was stuck on!
Ahhhh, I love a bit of credit
Glad it helped, Gustaw let me know on the couple of bits I missed out on, like the line at the bottom and top of the bar chart. He also, rightly, called out the colour of the Y Star Axis wasn’t the same as the Star KPI at the top.
I genuinely woke up, the day after I posted mine, and my mind went ping…“ah he put white lines on his matrix to create the effect of the light grey being a surround”
Lots of small details can add up to big things!
Really enjoy this data visualization workout 001 - Ratings
Here it is my submission
Ratings workouts Gustaw Dudek.pbix (118.5 KB)
I am stuck, I can’t make the values in the Scale columns disappear.
thank you for your help.
Use the magic formatting trick of 3 semi colon’s ;;
You can apply “;;;” format for your duplicated measure (i.e. for Reviews v2, and Avs Score v2).
It’s best to apply format using built-in format pane on the top ribbon, istead of using “format” function.
instead of i.e. whole number, you can rewrite to ;;;