@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
Great workout - need some additional formatting and report title but here it is:
Rating_Example.pbix (44.2 KB)
Really top work!
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)
@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)
Really enjoyed this one, learnt some visualisation and design tricks that will definitely be using going forward!
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)
Hi,
I am stuck, I can’t make the values in the Scale columns disappear.
thank you for your help.
Rémi
Use the magic formatting trick of 3 semi colon’s ;;
Hello @Remi10
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 ;;;
Thank you both, I’ve been searching for more than an hour.