CRUSHING requirements with Small Multiples in Power BI

[@fallinginthed33p]

The amount of info condensing is awesome. Color, line shape, min max points, small multiples all in one visual.

[@rhtn2001]

Love how you utulized the dax formula for the conditional formatting. Thanks!!!

[@PcGeek04]

Why can’t I stop smiling at his videos.

[@morris5984]

One of the few people I know that makes data truly entertaining. Thanks Patrick!

[@trisabiswas9375]

The most amazing part was when you did the conditional formatting on the bar chart and then switched back to the line chart. Really smart!! Loved this video!!

[@PeterKontogeorgis]

100% this!

[@aerobrain2001]

Never knew what small multiples were but this is exactly what I needed for one of my reports!!! Thanks!

[@roseventura1711]

I always, Always, ALWAYS learn something when I watch your videos! Excellent job!!

[@lopypop]

Love your presentation style, Patrick! Clear, informative, and I found myself smiling the whole way through. Keep it up! btw- I like how you show the problem-solving process (including the attempts that didn't work) because you're teaching us how to figure out new solutions on our own.

[@nirvairkhanuja]

This is so cool in so many ways. Patrick always makes a way to include some dax.

[@joeseroski1095]

Love when you do conditional formatting with DAX. I need to do some work in that area.

[@LeighRadmore]

That visua-switcheroo to get the extra functionality you want out of it is bananas!

[@evnpresson7258]

Thanks Patrick! I love small multiples but like you, I have only recently started playing around with them. Unfortunately the lack of asynchronous y-axis is a real blocker for me since my scales are usually very different between my dimensions and I really need different scales. I saw it's in the road map but still waiting on it to really start using the feature.

[@pabeader1941]

Synchronous axis are a hallmark of small multiples. if you are having scale issues, create 'cheater' measures that adjust the values to match the overall scale.

[@sibinsunny5323]

@@pabeader1941 will appreciate if you can give more direction around cheater measure to dynamically scale the small multiple axis. Though I like the small multiple feature but to what @Evn said most of time the categories need different scale.

[@pabeader1941]

@@sibinsunny5323 You don't change the axis scale. You change your 'data' to match the scale. I do it often when you want to show multiple lines on the same graph and one of them is much smaller then the rest. In some cases I've had to multiple by 100 just to get them to be visible.

[@dpi3.14]

Indeed, unsynchronized y-axis is a must-have feature. I couldn’t believe they didn’t add it by default. I think like half of scenarios where I could use small multiples is blocked now, basically I can only use it with relative kpi’s but not with absolute values as they always vary a lot

[@rajarshisingh2547]

Thanks Patrick, great video I didn't know earlier when to use them exactly and now I do. You have just reduced the number of pages in one out of 30 reports I own to around 20%.

[@mdhidayat5706]

Very cool way of displaying small multiples. Going to build this right now.

[@TheProjectCorner]

Putting the Wow in Small Multiples! Nice, I also see new features added to the option that weren't yet there when I did my video on the topic. Great work as always guys!

[@nazimscr]

Now I see the benefits of small multiples. thanks Patrick, you are my Power Bi guru.

[@ca1ifax]

You guys continue to make me feel like a noob. I kid! I kid! 😂 I love your content! My go to page whenever I'm stuck with a problem. Keep 'em coming!

[@sonetmollick4630]

Patrick, I am super excited to use small multiples. I love how you said "Just like that" :D

[@mwaltercpa]

“Were you exited? … I wasn’t.” 😂 Thanks Patrick, this is $$$$.. I’ll use ALL these tips.

[@jabelltulsa]

That's amaze. Great video!! I see so many times I could've used this.

[@javiergonzales6118]

Pretty cool tricks in this video, Patrick. Thanks

[@randalltucker9343]

Awesome video Patrick…I’m going to have to see if that’s available to me, and experiment with it if it is. 👏✌️

[@nadeemrajabali7839]

Love it Patrick. Can we use a dynamic list for small multiples? For example I want to see my monthly sales of Top 20 or 30 products. So this TOP N list is my small multiples to display.

[@sahilsinghal9472]

Excellent video. Thank you

[@sarajvo2010]

Great presented, as always! Thank you

[@ВладимирИваненко-е6у]

Patrick, you are the best))) thx for best practices ))

[@mr96908]

Great video Patrick....but how to make the grid layout option dynamic (say based on slicer selection)

[@stinaintx]

I’m inspired to try small multiples now!

[@pccl87]

Never used it before, but I'm gonna now!

[@pabeader1941]

I did the repeat and change 59 times for a report I needed. Still using that report, that way, 3 years later.

[@stopthink9000]

Cool! Works like "facet" function in R! Nice and easy!

[@tomgee4165]

Awesome - I'm stealing this trick!

[@naylord5]

Sweet baby Jesus, so much knowledge in just 5 minutes, simply amazing!

[@dnordon]

Thanks

[@MarioG83]

I already did a lot of research around conditional formatting on line charts... and suddenly there it is. This is something really need to be fixed and properly implemented instead of using the "workaround".

[@ahmedtareq5342]

WOW, you keep amazing me man, keep up the great work

[@ececphuah5868]

Thanks, Patrick. I've learnt a lot from your video ! But if I were to replace Year with Month, I can't see the Highlighted Min & Max month ? appreciate your advise! Thanks again!

[@klimentgrozdanoski]

Great video Patrick!

[@rossybink]

This was great, nice work.

[@ianantha]

Thanks Patrick! this was very helpful "but" I have a situation where I don't have the fixed number of categories to use in small multiples. is there any way we can adjust the grid based on the numbers either rows or columns?

[@sonsangsom]

Amazing, thanks! Anyhow we can get the data file to practice?

[@vilmarsantos3419]

Muito bom!! Também já tive varias dessa reação 3:57

[@magnusp2313]

Holy crap - thanks for that video 😎

[@ajaaskelainen]

This blew my mind! than you

[@bellobello7366]

Hi Patrick, for small multiple, can we setup different axis range in Y-axis

[@tarun007]

Fantastic, Patrick !!

[@CaribouDataScience]

How can I set the y axis for each plot?

[@laryssasnascimento]

Hey Patrick, do you know if it's possible to have different Y axis for each part?

[@gonzalorengifo1031]

Great job Patrick would it be possible for you to share the pbix file?

[@fredspxs4allnl]

Hi Patrick, I Used your beatiful example in many of my Power BI courses but since Feb 2022 version it does not work anymore. If i dont use ALL in sumerize then all the small m should become green because of filter context but now some will be green and some red????. ALL still works, AllSelected is also weird is do show the red one but not the green one, what happened?

[@coc_cthulhu2042]

Hi Patrick! Thanks for the video. I'm trying to use small multiples but I don't have preview features available. I'm using PBI Desktop Optimized for Report Sever (May 21)... Could this be the reason? 🤔

[@pedrocalvino4877]

Hello, very interesting! Does anyone know how to make the scale of the Y axis adapt to the information of each graph? Thank you

[@sergejamie440]

Hi I'm also struggling with the Y axis, is there a way to force small multiples to use the same values for x and y axis?

[@FrankyLeeuwerck]

Great video !

[@quentinwinisdoerffer421]

Aaaaanndddd here is the difficulty: how can you sort the multiple visual by the measure value to first show the highest? ;) Good luck with that one!

[@PavanKumar-nx6dn]

This is awesome!!!

[@MuhammadBerki]

Wow mind blown 🤯

[@juanignacioXI]

Hi Patrick, an error is show when i try to use the DAX for the BG, the message is the following: MdxScript(Model) (97, 54) Calculation error in measure 'TablaMedidasCore'[Small Multiple BG Color]: A table of multiple values was supplied where a single value was expected. Any idea to solve this?, Thanks in advance!

[@udayshankarnellore]

Q) Hi Patrick For small multiples I have Month Year in X-axis and I have 3 years data. Am not able to sort it in Month Year order. Currently am getting as Below Jan-2021 Jan-2022 Feb-2020 Feb-2021 Please help with the proper sorting

[@jelledaems808]

Hi Patrick, thank for the video! I was recreating my own example based on this and I created the exact same measure as you for the background color, but I keep getting an error when calculating the _bottomCountry saying that "he gets multiple values while one value was expected". I'm not sure why he's giving that error in my example

[@Дархан-г4ъ]

Nice one!

[@knutwolgast8623]

Does it work on the PBRS?

[@icedojo]

AMAZING!

[@raghunadhamara6243]

Hi Patrick can we do that coloring without dax o really hate those complete dax. Please help ok dax

[@omaroak8374]

what is equation for ((Total sales Amount ))

[@AmarSi218]

Genius ❤

[@oliverhunt1459]

You really need to get a full requirements spec up front! None of this "Thanks but can you add this..."!

[@charlottep.4843]

Cool!

[@eriol33]

genius!

[@ИльяСмирнов-ж8я]

I got up

[@KiselGreg]

Огонь!

[@missmalrun]

Как поставить 10 плюсов за это видео? Очень круто, спасибо большое!

[@prakhargarhwal4304]

Here before 1000 views

[@ospino1112]

Damn

[@mmtindaro742]

its someone you ? :)

[@DavidBridgeTechnology]

So what would your mother say?

[@alfredsfutterkiste7534]

"That's not what my mother would say"... I think she would say something along the lines of "Your mouth is writing checks that your a** can't cash!"

[@egorshiyanov1206]

I think I found the video with the column chart trick (look at 12:15 or something like that) kzbin.info/www/bejne/iWipmWWiYpmdosU

[@nashiki4792]

First

[@roadtech6472]

Amazing tips Patrick! Thanks!