The amount of info condensing is awesome. Color, line shape, min max points, small multiples all in one visual.
@rhtn2001
3 жыл бұрын
Love how you utulized the dax formula for the conditional formatting. Thanks!!!
@trisabiswas9375
3 жыл бұрын
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
3 жыл бұрын
100% this!
@morris5984
3 жыл бұрын
One of the few people I know that makes data truly entertaining. Thanks Patrick!
@aerobrain2001
3 жыл бұрын
Never knew what small multiples were but this is exactly what I needed for one of my reports!!! Thanks!
@nirvairkhanuja
Жыл бұрын
This is so cool in so many ways. Patrick always makes a way to include some dax.
@lopypop
3 жыл бұрын
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.
@LeighRadmore
3 жыл бұрын
That visua-switcheroo to get the extra functionality you want out of it is bananas!
@evnpresson7258
3 жыл бұрын
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
3 жыл бұрын
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
3 жыл бұрын
@@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
3 жыл бұрын
@@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
2 жыл бұрын
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
@joeseroski1095
3 жыл бұрын
Love when you do conditional formatting with DAX. I need to do some work in that area.
@roseventura1711
2 жыл бұрын
I always, Always, ALWAYS learn something when I watch your videos! Excellent job!!
@ca1ifax
3 жыл бұрын
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!
@TheProjectCorner
3 жыл бұрын
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!
@mdhidayat5706
3 жыл бұрын
Very cool way of displaying small multiples. Going to build this right now.
@mwaltercpa
3 жыл бұрын
“Were you exited? … I wasn’t.” 😂 Thanks Patrick, this is $$$$.. I’ll use ALL these tips.
@nazimscr
3 жыл бұрын
Now I see the benefits of small multiples. thanks Patrick, you are my Power Bi guru.
@klimentgrozdanoski
3 жыл бұрын
Great video Patrick!
@sahilsinghal9472
3 жыл бұрын
Excellent video. Thank you
@rajarshisingh2547
3 жыл бұрын
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%.
@sonetmollick4630
3 жыл бұрын
Patrick, I am super excited to use small multiples. I love how you said "Just like that" :D
@mr96908
6 ай бұрын
Great video Patrick....but how to make the grid layout option dynamic (say based on slicer selection)
@pabeader1941
3 жыл бұрын
I did the repeat and change 59 times for a report I needed. Still using that report, that way, 3 years later.
@javiergonzales6118
3 жыл бұрын
Pretty cool tricks in this video, Patrick. Thanks
@dnordon
2 жыл бұрын
Thanks
@nadeemrajabali7839
2 жыл бұрын
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.
@stopthink9000
3 жыл бұрын
Cool! Works like "facet" function in R! Nice and easy!
@CaribouDataScience
Жыл бұрын
How can I set the y axis for each plot?
@naylord5
3 жыл бұрын
Sweet baby Jesus, so much knowledge in just 5 minutes, simply amazing!
@MarioG83
3 жыл бұрын
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".
@user-qc7eb8mf4z
3 жыл бұрын
Patrick, you are the best))) thx for best practices ))
@jabelltulsa
3 жыл бұрын
That's amaze. Great video!! I see so many times I could've used this.
@roadtech6472
3 жыл бұрын
Amazing tips Patrick! Thanks!
@FrankyLeeuwerck
3 жыл бұрын
Great video !
@pccl87
3 жыл бұрын
Never used it before, but I'm gonna now!
@randalltucker9343
3 жыл бұрын
Awesome video Patrick…I’m going to have to see if that’s available to me, and experiment with it if it is. 👏✌️
@sonsangsom
2 жыл бұрын
Amazing, thanks! Anyhow we can get the data file to practice?
@ajaaskelainen
3 жыл бұрын
This blew my mind! than you
@stinaintx
3 жыл бұрын
I’m inspired to try small multiples now!
@bellobello7366
2 жыл бұрын
Hi Patrick, for small multiple, can we setup different axis range in Y-axis
@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?
@ececphuah5868
3 жыл бұрын
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!
@magnusp2313
3 жыл бұрын
Holy crap - thanks for that video 😎
@user-ll2sn8kp8w
3 жыл бұрын
Nice one!
@tarun007
3 жыл бұрын
Fantastic, Patrick !!
@MuhammadBerki
3 жыл бұрын
Wow mind blown 🤯
@ahmedtareq5342
3 жыл бұрын
WOW, you keep amazing me man, keep up the great work
@vilmarsantos3419
3 жыл бұрын
Muito bom!! Também já tive varias dessa reação 3:57
@laryssasnascimento
2 жыл бұрын
Hey Patrick, do you know if it's possible to have different Y axis for each part?
@rossybink
3 жыл бұрын
This was great, nice work.
@gonzalorengifo1031
3 жыл бұрын
Great job Patrick would it be possible for you to share the pbix file?
@tomgee4165
3 жыл бұрын
Awesome - I'm stealing this trick!
@sergejamie440
2 жыл бұрын
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?
@icedojo
2 жыл бұрын
AMAZING!
@pedrocalvino4877
3 жыл бұрын
Hello, very interesting! Does anyone know how to make the scale of the Y axis adapt to the information of each graph? Thank you
@knutwolgast8623
3 жыл бұрын
Does it work on the PBRS?
@fredspxs4allnl
2 жыл бұрын
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?
@PavanKumar-nx6dn
3 жыл бұрын
This is awesome!!!
@omaroak8374
3 жыл бұрын
what is equation for ((Total sales Amount ))
@quentinwinisdoerffer421
3 жыл бұрын
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!
@AmarSi218
Жыл бұрын
Genius ❤
@coc_cthulhu2042
3 жыл бұрын
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? 🤔
@juanignacioXI
2 жыл бұрын
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!
@charlottep.4843
2 жыл бұрын
Cool!
@oliverhunt1459
3 жыл бұрын
You really need to get a full requirements spec up front! None of this "Thanks but can you add this..."!
@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
@raghunadhamara6243
3 жыл бұрын
Hi Patrick can we do that coloring without dax o really hate those complete dax. Please help ok dax
@jelledaems808
3 жыл бұрын
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
@user-bd4vb4lj6p
3 жыл бұрын
I got up
@missmalrun
3 жыл бұрын
Как поставить 10 плюсов за это видео? Очень круто, спасибо большое!
@KiselGreg
3 жыл бұрын
Огонь!
@eriol33
3 жыл бұрын
genius!
@ospino1112
3 жыл бұрын
Damn
@prakhargarhwal4304
3 жыл бұрын
Here before 1000 views
@mmtindaro742
3 жыл бұрын
its someone you ? :)
@egorshiyanov1206
2 жыл бұрын
I think I found the video with the column chart trick (look at 12:15 or something like that) kzitem.info/news/bejne/tG18zmaiZmabn5g
@DavidBridgeTechnology
2 жыл бұрын
So what would your mother say?
@alfredsfutterkiste7534
2 жыл бұрын
"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!"
Пікірлер: 85