Fantastic attempt. Well done
1 Like
Really well done. Great to see max effort on this workout
3 Likes
Hi there,
Could I get some help please? I am stuck on the chart. I have used a technique by Sam to get the TopN
This measure works fine on the chart if I only select client for y axis. If I select business line & client for y axis it won’t work 
It does however work if I select year & client for y axis
Any tips that could point me in the right direction would be appreciated.
pbix is attached
Workout #5 Hierarchy Bar Chart TopN KimC v1.pbix (209.7 KB)
1 Like
Hi all,
This is my approach to WO5. Thank you Gustaw for this challenge. It’s “Think outside the box” for me. I have just started learning how to implement multi-level filtration in visualizations using DAX. It’s not easy, but I’m doing my best. Thank you for this opportunity.
Workout 005_EDNA_AngelinaMihejenkova.pbix (634.9 KB)
3 Likes
Hi, here is my submission to the workout challenge
No idea about the sorting and getting the displayed metrics as both metrics working
Hope I did it justice
EDNA Visuals 005.pbix (451.3 KB)
Report Link
1 Like
I have worked this out 
If anyone else is stuck on this step, check this out:
1 Like
hi,
very strong workout !
I had a lot of troubles with the two level ranks (first by Business Line, second by Customer). In current pbix I used, as first level, a method based on an IF considering that Business lines are only two… but I am not fully happy…
I also see GM% and Profit% show incorrect values…
Anyway I enjoyed doing the full workout even if, every time I look at Gustaw’s viz, I discover something new.
Ciao !
Workout 005 - hierarchy bar chart and top N selector - Roberto Ravani.pbix (452.3 KB)
2 Likes
I “think”, to get both metrics to display at one time you need to use some data modelling.
I created two Field Parameter tbls, duplicated each measure in the table and created a master Param Filter table to filter down to either one measure or both. This also involves two of the parameter fields being placed in your values field.
This was how I approached it, not sure if it’s the best way to do it but it seems to work for me…now I just need to review my TopN measure as that is throwing out some funky numbers 
To be honest, I’m not 100% sure my method is the way to do it, just thought I’d post in case it helps others get a working solution.
5 Likes
oh, I see. Very creative.
2 Likes
Hello everyone,
Here is my submission for the workout challenge. This challenge was a tough one! I pushed myself to the limit and gave it my all but still I couldn’t complete all the elements such as sorting and displaying metrics.
Thanks again to @Gustaw for putting on this competition and giving me the opportunity to showcase my skills.
Interactive report:
PBIx file:
Workout 005 - Revenues & Gross profit – bar chart and TOPn selector_.pbix (646.4 KB)
3 Likes
Hi @ErmanA,
It looks absolutely phenomenal, even without sorting order.
Appreciate your great effort put into this one!
Amazing work - great design, buch of functionalitites (hierarchy / tooltips / sorting by different metrics / headers etc).
Thank you for participation!!
1 Like
@KimC ,
It already looks wonderful.
Practicing the use of hierarchical axis was the most important action here.
Really great to see such functionalities as such hierarchy, TOPn slicer, headers (titles).
Amazing work!
@DavieJoe
Awesome idea to link both field parameters using an additional table.
In that particular case/workout, it’s not necessary, because my intention was to actually have two separate slicers, one specifically for determining the sorting measure, and the second one determining what we actually want to see/display on a chart.
However, I was actually thinking about it a lot when creating such workout (wheter to use them as separete “choices” or connect them. I think all options are valid, so it’s totally fine that propose your own solution. It’s really awesome to incorporate individual ideas and contexts, if you will it’s instrumental in the analysis!
Thank you for your feedback on this!
1 Like
Hi @Roberto2
Totally awesome implementation!
Hierarchical y-axis / metric selection (“display as”), topn-selector, tooltip - lot’s of great features here!
I also appreciate your additional effort to create dynamic display of data labels (bottom left corner of the report).
Amazing work as always!
Thank you for participation!
1 Like
Hi @jtej001
Cool entry, clean & elegant as always!
So many features implemented. All looks great!
Displaying “both metrics” has been applied by using 4 measures within a field parameter and by adding one extra category (group) for 3rd and 4th measure, that get the same ID and name ‘both metrics’.
Case of sorting actually puts the substiantial limitiation (in my personal opinion) when it comes to using hierarchical y-axis (and maitaining proper hierarchical look of axis). I hope it’s something that will be upgraded by MS team in the future. What do you think?
Thank you for participation!
There are so many great things in your entry: TOPn selector, additional custom tooltip, different metrics (“Displayed as”), titles and subtitles. All looks really clean!
Congratulate and thank you for participation!
1 Like
Hi @renata_kulagowska
There is already ton of great work put into the entry!
The whole set up looks exactly as it should be.
|'m not sure if you would have a change to make the minor adjustments, but it’s already great.
The only one, small thing that we could additionally think of would be to change the main measure a bit, so each business line would get the same amount of items (in general).
Great work as always. Appreciate your blazing-fast entry and thank you for participation!