So, 8 minutes into the video, I realised I was holding my breath... Bas is going to come with some head-turning DAX!... And then, it came! 😉 Only, this time, it is that DAX I never thought I already knew! But thank goodness, there are ways to make beautiful PowerBi dashboard without DAX... Only when you're subscribed to HowToPowerBi! Thanks, Bas! You really are the MVP...Got that, @Microsoft?
Love your videos. Best Power BI teacher on youtube! Loving all the design tips too. One request, could you please use a wider array of industry examples .. there's more than just financials out there - like digital twin and IOT or sports stats.
Great Video! Thank you so much. I always have the problem with sparklines once a filter to the date column is applied. Especially bad, if you are connected with a Live Connection and there's no way to alter the underlying data model. I would probably need 2nd date dimension in the data model? What I want to achieve e.g. with the KPI cards as shown in the video is to output the value from yesterday but to show lines from the last xx days. Or show an aggregated month value and compare it agains previous xx months with the line.
Your channel deserve to be a million view hit you are the best all time no one beat your content and way you explain keep working on it inshallh you will achieve millions of hit for sure god bless you lots of love from dubai uae 😘😘😘😘
OMG!!!!!! You did it again!!!, Bas is the boss!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1 thank you once again!!!!!!!!!!!!!!!!!!! Merry Christmast and the greatest 2022 for u!!
Once again, what a great idea! I just had a play around with it and used the same logic to display different measures ( rather than using a product dimension for example), and I think it's a great substitute for the traditional KPI card. Thanks!!
Hi Bas, was playing around with this as well but where you take product and put it in values (where it changes to 'First Product') that does not work for me. I take it not every field can be added to values. But you product is also just a text field I presume just like the field I would like to add. Would you happen to know what can cause this?
great video (as always) but I stuck at point where you add photos. If I add them to row/column header it shows just fine but when I add them to value field it returns blank (when it shows "first product image). Any advice?
Bas - Have you noticed the tooltips that come up when you hover over the points? It's hard to decipher exactly what the context is and sometimes it tells you what the trend was and sometimes just absolute values. But they seem a bit confusing. Would be awesome if you could do a video that could add some clarity to what the tooltips on Sparklines are trying to tell us!
@@HowtoPowerBI Dude you're just brilliant. Which country are you in, l think I'd definitely enjoy a beer with you. Do you know that just from the skills I've collected from you, I've secured myself a Job l would have never stood a chance for a year ago.
Another great video Bas. How are you finding the new formatting pane? In the bit that I’ve used it, it seems to take a lot more clicks to find things. Hopefully it’s just because I’m not used to it yet!
thanks Peter! I Like the make-over - at the beginning also a bit of searching around - but I think it's a good effort to have everything a bit more organized compared to how it used to be
@@HowtoPowerBI funnily enough since I left that comment I've been using the new format pane daily - definitely a big improvement once you get used to where everything is.
Great video, Great explanation, I have one doubt on this while adding images in the Values for me its coming only first or last image can you please how to achieve all images respectively. Thank you BAS
Thank you Bharath. You can only show 1 images per item. So lets say you have product category then you would also need to add the field products to show all product images for that category
Hai I Really Like Your Videos. it's Really Good. I have One Question? How To Apply Filter Condition By Using Power Query? I have 6 Months of Data! But I Need Latest 3 Months Data Only For every Month. How To Achieve it? Could Please Explain! Thanks in Advance!
Hi, I used to watch your videos to learn Power BI. I need you help in conditional formatting . I have 3 target for complete year(I.e Entry/Target/Max) for 53 offices and every office has different targets{for example Office A has "Entry-5, Max-5.5 and Target 5.7 and Office B has Entry-4, Max- 4.05 and target- 4.07) Have to monitor weekly performance. Can you help me how to put conditional formatting by creating measure- have watched you video but not able to understand- Thanks in advance
Your videos show that you are a creative person. Can I teach this tecnique on my TH-cam Channel? That way, The brazilians who accompany me will be able to learn.
So, 8 minutes into the video, I realised I was holding my breath... Bas is going to come with some head-turning DAX!... And then, it came! 😉 Only, this time, it is that DAX I never thought I already knew!
But thank goodness, there are ways to make beautiful PowerBi dashboard without DAX... Only when you're subscribed to HowToPowerBi!
Thanks, Bas! You really are the MVP...Got that, @Microsoft?
Love your videos. Best Power BI teacher on youtube! Loving all the design tips too.
One request, could you please use a wider array of industry examples .. there's more than just financials out there - like digital twin and IOT or sports stats.
Thank you, Bas! Really learning and taking up a lot of notes from your videos.
Great video, Great explanation, please continuous to share your knowledge.
Thank you BAS
Great Video! Thank you so much. I always have the problem with sparklines once a filter to the date column is applied. Especially bad, if you are connected with a Live Connection and there's no way to alter the underlying data model. I would probably need 2nd date dimension in the data model?
What I want to achieve e.g. with the KPI cards as shown in the video is to output the value from yesterday but to show lines from the last xx days. Or show an aggregated month value and compare it agains previous xx months with the line.
Your channel deserve to be a million view hit you are the best all time no one beat your content and way you explain keep working on it inshallh you will achieve millions of hit for sure god bless you lots of love from dubai uae 😘😘😘😘
Wow this comment made my day! Thank you 🤩😍
OMG!!!!!! You did it again!!!, Bas is the boss!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1 thank you once again!!!!!!!!!!!!!!!!!!! Merry Christmast and the greatest 2022 for u!!
Thank you for this interesting and exhaustive review of the functionality.
thx for watching again Mehdi! 🙂
Once again, what a great idea!
I just had a play around with it and used the same logic to display different measures ( rather than using a product dimension for example), and I think it's a great substitute for the traditional KPI card.
Thanks!!
I love the way you go In Details and explain the limitations of the visuals. This saves tons of time for me
Thanks
Brilliant! And the final result looks so good!
I’d also check how this trick can impact performance. I assume it helps as we still build a single visual.
Hi Bas, was playing around with this as well but where you take product and put it in values (where it changes to 'First Product') that does not work for me.
I take it not every field can be added to values. But you product is also just a text field I presume just like the field I would like to add.
Would you happen to know what can cause this?
Your tutorials are on another level
Excellent video! Thx
Oh wow, thank you so much for sharing this. It is very impressive. I've learnt a few things here I never know existed before.
Great video, Bas! Thanks for sharing!
thx Lisa for watching!!!! 🙂
Your tips are amazing!! Thank you so much for share it with us!!
Excellent as usual
every tip can save a lot of effort , time
Thanks Azo!
Just another amazing video!! Thank you so much
thx Ahmed! 😊
Very good !!! thank you for sharing !!
thank you!!!
I didn´t know about the "text wrap" shifter so far. Thx!
great video (as always) but I stuck at point where you add photos. If I add them to row/column header it shows just fine but when I add them to value field it returns blank (when it shows "first product image). Any advice?
Bas - Have you noticed the tooltips that come up when you hover over the points? It's hard to decipher exactly what the context is and sometimes it tells you what the trend was and sometimes just absolute values. But they seem a bit confusing. Would be awesome if you could do a video that could add some clarity to what the tooltips on Sparklines are trying to tell us!
Excellent Video. Thank you!
Goede uitleg weer and I especially like your 'tricks' 🙂
dankjewel Gerald!!! 😊
Again, awesome video, thank you for a great introduction to Sparklines.
excellent !!! as usual explanation is wonderful, thanks Bas
thanks santhosh, much appreciated!
Great feature!
definitely is, import one that was still missing!
Thank you 👍
thx for watching again Bharath!
Never thought of this. You are a champ bro...keep sharing !!
😎👊😊
I do not have the Option button under the value, how come? I cannot find other features u are showing
You need to update power bi (only available from version dec 2021)
@@HowtoPowerBI I do have it, but still the switch to columns under value and all the subtotals do not appear
Awesome! Thank you!
Great video (as always) !!
Amazing!
thank you Gambu! 😎👊
@@HowtoPowerBI Dude you're just brilliant. Which country are you in, l think I'd definitely enjoy a beer with you. Do you know that just from the skills I've collected from you, I've secured myself a Job l would have never stood a chance for a year ago.
That just made my day! Congratulations on the job 💪 I'm in Germany, Düsseldorf so if you are ever around let me know 🍻😊
Another great video Bas. How are you finding the new formatting pane? In the bit that I’ve used it, it seems to take a lot more clicks to find things. Hopefully it’s just because I’m not used to it yet!
thanks Peter! I Like the make-over - at the beginning also a bit of searching around - but I think it's a good effort to have everything a bit more organized compared to how it used to be
@@HowtoPowerBI funnily enough since I left that comment I've been using the new format pane daily - definitely a big improvement once you get used to where everything is.
Thk y, Great Videto
thx Jair!
Just to say, that's so cool.. thanks.
You're awesome. Could you please do some videos on formatting of final dashboard picking color's .
Great video, Great explanation, I have one doubt on this while adding images in the Values for me its coming only first or last image can you please how to achieve all images respectively.
Thank you BAS
Thank you Bharath. You can only show 1 images per item. So lets say you have product category then you would also need to add the field products to show all product images for that category
@@HowtoPowerBI now its working. Thank You soo much
Please advise if this feature has been rolled out in the updated version or not?
Hi Dinesh, yes it is available from dec 2021 version
Great work bro.. can you do video on many to many relationship for 2 fact tables.. thank you
thx Chandra for the video idea! 🙂
This feature is not showing in my personal power bi desktop, why so?
You need to update your power bi version to december 2021
Wow everytime something comes from u
that's really nice to hear - thank you Pavan! I appreciate you watching 😊
Hai
I Really Like Your Videos.
it's Really Good.
I have One Question?
How To Apply Filter Condition By Using Power Query?
I have 6 Months of Data!
But I Need Latest 3 Months Data Only For every Month.
How To Achieve it?
Could Please Explain!
Thanks in Advance!
knowledgeable viedo tq
Thanks Jawaheera!
Oh man, mind blown.
Thanks GhostGirl :)
Very good, as usual.
You spoil your followers 😂😂😂😂😂😂😂
It's been a good update, December.
early christmas present 😄🎄
What a pity, it doesn’t work in direct query :(
oh nooo 😕 I think it will be though
Super goed !
Супер!!!
Hi, I used to watch your videos to learn Power BI.
I need you help in conditional formatting .
I have 3 target for complete year(I.e Entry/Target/Max) for 53 offices and every office has different targets{for example Office A has "Entry-5, Max-5.5 and Target 5.7 and Office B has Entry-4, Max- 4.05 and target- 4.07)
Have to monitor weekly performance. Can you help me how to put conditional formatting by creating measure- have watched you video but not able to understand- Thanks in advance
just Wow
😊
Your videos show that you are a creative person. Can I teach this tecnique on my TH-cam Channel? That way, The brazilians who accompany me will be able to learn.