*Bas, your creativity knows no bounds; I'm continually amazed at the limitless possibilities you bring to life.*
@AndyDevineUK
11 ай бұрын
Totally agree 👍👍👍
@HowtoPowerBI
11 ай бұрын
thank you for the kind words - so nice to hear 😊
@deepakcitm
11 ай бұрын
Completely agree 👍
@lingambalakrishna
10 ай бұрын
I had been appraised from my management using your dashboard design ideas Cool
@madluke7897
11 ай бұрын
Great video, as always! Tip: if you create the disconnected table with curly brackets via DAX expression, you can use the normal sort by function in the column settings. CurlyTable = { ("Ordered",1), ("Shipped",2), ("Delivered",3) } will give you the table; the columns can then simply be renamed afterward.
@HowtoPowerBI
11 ай бұрын
thank you! didnt know 😁
@amorimxv
11 ай бұрын
Visually minimalist, but very efficient and intuitive. Very good!
@HowtoPowerBI
11 ай бұрын
Thank you! 😊
@MelBoulds
6 ай бұрын
Another great visual built using native visuals. I can't get the highlight to equal 1 for previous stages in the order though, only the current status is calculated as 1. Processing Highlight = VAR _SelectedStatus = SELECTEDVALUE('Sales Order Lines'[StatusIndex]) VAR _SelectedStatusNr = CALCULATE( MAX('Processing Status'[Order]), 'Processing Status'[StatusIndex] = _SelectedStatus ) VAR _Result = IF( SELECTEDVALUE('Processing Status'[Order])
@omarhadidy4968
4 ай бұрын
Did you find a solution to that problem ? I have the same issue
@adsomvieira7331
4 ай бұрын
I also have this problem, has anyone managed it?
@victordelima7789
4 ай бұрын
I had the same issue, but I solve it using a FILTER+ALL in CALCULATE measure. CALCULATE( MAX('Processing Status'[Order]), FILTER(ALL('Processing Status'), 'Processing Status'[StatusIndex] = _SelectedStatus )) Now, we can see all status no matter what. ;)
@MelBoulds
4 ай бұрын
@@victordelima7789 Thanks for your reply. I applied your DAX logic and it solved the issue I had. 👍🏼
@AlejandroGonzalez-vk1zz
3 ай бұрын
@@victordelima7789 Thanks for share
@keagankemp6275
11 ай бұрын
I am sending a petition to Microsoft let’s change the name from PowerBI to BasBI lol you are a master of your trade, thank you I needed this.
@HowtoPowerBI
11 ай бұрын
haha I like that Idea ,.. can you also ask if they change the logo to my youtube pic 😂
@gustavopedrazzini5110
7 ай бұрын
Hi Bas, thanks for your content. I have a problem with the Dummy Line Highligth metric because in the line chart it only shows me the marker where the data is located, and not the whole line as in your video. Do you know what it could be? Regards
@zoewebb8060
4 ай бұрын
Any luck fixing this? I’m having the same problem…
@myskr-ds6qk
4 ай бұрын
@@zoewebb8060 same problem huhu
@anishagupta12345
11 ай бұрын
Excellent video😍🤩 I wanted to make a request that there is a new feature that came in AWS i.e. AWS QUICKSIGHT which is also a data visualization tool . My kind request if you could make such innovative videos of how we can make the same visualizations in AWS QUICKSIGHT TOO
@victorsalaspsalas3119
10 ай бұрын
Your teaching is great, thank you very much for this new knowledge.
@ErghePoston
8 ай бұрын
Hey Bas, great video as always! I have a huge issue that seems evasive in Power BI... Change data capture, or showing new/changed records since last refresh. Think that would be a worthwhile video? Seems like something most of us could use. Thank you for all your help!
@philoooooo
11 ай бұрын
Hi Bas wonderful work ! I learned a lot. One small improvement can be done is that you either don’t show the check mark on the order status that is not achieved yet or show another check mark that means not done !
@HowtoPowerBI
11 ай бұрын
yea initially build it of a real example from a web store.. maybe better to have a different icon there
@melissarolim
10 ай бұрын
You are incredible! This helped me a lot! Thank you so much for sharing your knowledge this way!
@adityaanand02
11 ай бұрын
Need a video on a time tracker like this. For example: estimate completion date and today’s date Btw thank you very much these videos are amazing
@HowtoPowerBI
11 ай бұрын
like a gantt?
@adityaanand02
11 ай бұрын
Maybe one progress bar with runs as a timer (but for date) no need to change the data, it just adjusts with today's date @@HowtoPowerBI
@mathaem
10 ай бұрын
Love it as always ! Thank you from France 🙏
@narendrababu2287
11 ай бұрын
I would like to implement in my recruiting dashboard. This will be a great insight.
@HowtoPowerBI
11 ай бұрын
awesome 😎👊
@raynier1993ify
10 ай бұрын
Hi, how could I create the same graphic with the flags?
@julieperron-rk5ys
11 ай бұрын
Love seeing your new content. I will definitely use this in my work. Cant wait for the next amazing video.
@HowtoPowerBI
11 ай бұрын
awesome 😎👊
@ahmedtharwat5156
10 ай бұрын
Really it is amazing , all your designs are amazing and out of box thanks man
@HowtoPowerBI
10 ай бұрын
Thank you so much 😀
@JonathanCHANAL
11 ай бұрын
Great job! You have demonstrated a very interesting use case and shown great creativity. Well done and congratulations! :)
@HowtoPowerBI
11 ай бұрын
Thank you so much 😀
@perryagyemang9369
Ай бұрын
How did you get the cards to display the other information on the ID?
@LehlohonoloMakoti
11 ай бұрын
Nice clean design
@HowtoPowerBI
11 ай бұрын
Glad you like it! 😊
@kasuniharshika601
2 ай бұрын
Wht a brilliant man. Thank you❤
@bejukacarlson6454
11 ай бұрын
Thanks for this amzing video. I would like to have the complete video which explains how the other elements in the report were created, in order to practice and develope ideas. Thanks.
@HowtoPowerBI
11 ай бұрын
check the file (see download in description)
@jhazielpetersen761
11 ай бұрын
Always a head turner visualization tutorial
@HowtoPowerBI
11 ай бұрын
thank you! 😁
@edinsoncardenas8730
6 ай бұрын
Thanks a lot, But I have a problem,my "dummy highlighted" don't choose all the stage, it's just choosing a one. Forexample: Only Delivered is highlighted, not the first,second and third.
@ghnwgfghnb
5 ай бұрын
I have the same issue
@tovam9817
4 ай бұрын
Great video thanks! For some reason when I use a legned, the lines disapper between the diffarent categories, any idea why?
@unnikrishnansanthosh
11 ай бұрын
another feather in the cap BAS, thank you for sharing
@HowtoPowerBI
11 ай бұрын
thank you for watching and because of you I now know what another feather in the cap means 😅😁
@helenemartin6864
8 ай бұрын
Great Tutorial Bas, Are you using the latest PowerBI version for this? Let me know before I give it a go. Thanks!
@HowtoPowerBI
8 ай бұрын
Time of recording was october so that is the version used in the video :)
@dianestipertiwi7137
3 ай бұрын
Hi, I enjoy watching your Power BI tutorial videos and find them very impressive. I'm looking for a shipment video tutorial, but I couldn't find it on your KZitem channel. Where can I find a shipment tutorial video?
@HowtoPowerBI
3 ай бұрын
got a lot of videos on visuals that can be used for shipping, but not necessarily with a logistics application
@dianestipertiwi7137
3 ай бұрын
@@HowtoPowerBI thankyou for your response, Bas! How do I connect the shipment ID with its status?
@lumitic774
11 ай бұрын
omg... this uber incredible. top design and idea. i am sorry but will be copying!
@HowtoPowerBI
11 ай бұрын
have fun implementing 😉
@AlbertCat
2 ай бұрын
Bas, How could we make each step (circle) have a different color?
@derrickkuria4206
11 ай бұрын
Have been looking on how to achieve this....🎉🎉🎉
@HowtoPowerBI
11 ай бұрын
nice timing then 😁
@gezin_longuevilleosaer4245
11 ай бұрын
Schitterend, zoals altijd!!
@HowtoPowerBI
11 ай бұрын
dankjewel! 😊
@davidmoe4167
10 ай бұрын
Several days ago I thought I would like a tracker in my report. Just like that you post this video. Thank you! One issue I am having is I only highlight the max status not the previous steps. When I replace the VAR _nr with a number like 3 it works. When I use the VAR it only highlights the max status.
@davidmoe4167
10 ай бұрын
I had to create a measure calculate table of the order column to get the data to drop into the tooltip. Then sort by tooltip. If I sorted the status table in any way it only displayed the current step and not the previous.
@tasmiyakazi2386
10 ай бұрын
Will you please share your solution here, I am facing similar issue@@davidmoe4167
@nobackwheel
8 ай бұрын
@davidmoe4167 I also get this - did you work out the solution? VAR _NR is correct, but it doesn't work??
@davidmoe4167
8 ай бұрын
I had to create a measure calculate table of the order column to get the data to drop into the tooltip
@myskr-ds6qk
4 ай бұрын
@@davidmoe4167 how to do that? Can u paste the simple code for that?
@abdulrahmanalnajjar1496
11 ай бұрын
You really excelled in this video, but we need other cases of such a wonderful example. Frankly, I did the same idea, but the example is different and in a different, more complex way. Can I show you my work and you can give me your opinion?👍
@HowtoPowerBI
11 ай бұрын
sure, reality usually is a bit more complex ;) .. where did the extra complexity come from?
@EthanDu-b9y
9 ай бұрын
Hi Bas, your video was especially helpful for my task. I am having trouble with the color of the line highlight. Currently only the marker shows a different color and not the line before it. My visual looks like a grey line with grey markers and if the value was in the second position (sent) only that maker is blue. the line to the left of that marker looks grey still. If anyone can please help I would greatly appreciate it
@ghnwgfghnb
5 ай бұрын
I have the same issue. And i see here a lot of people are facing the same problem. Were you able to solve it?
@meghasharma7750
10 ай бұрын
You are a inspiration
@BjornV1976
10 ай бұрын
Very nice, but limited to the icons and emotics, but can it be done with PNG (base64 encoded) ?
@travelkare
7 ай бұрын
Dataset for practice BAS please , Btw awesome innovative work👏
@HowtoPowerBI
7 ай бұрын
See description
@niklass2374
6 ай бұрын
Great video, I particularly liked all the small formatting details. There is one detail that bugs me though. When one hover over the visual it says dummy this and dummy that. Would a custom tooltip be the best option here?
@HowtoPowerBI
6 ай бұрын
Yes go for a custom tooltip :)
@iliassbz3625
11 ай бұрын
Amazing Bas 🔥 you re a Power bi wizard
@HowtoPowerBI
11 ай бұрын
🧙♂️😎
@kumarvg5383
11 ай бұрын
Love the content 👌... Thanks for sharing 👍
@HowtoPowerBI
11 ай бұрын
😎👊
@TrassBI
11 ай бұрын
Amazing🔥Thanks for sharing your magic 🪄 ideas 💡🤩
@HowtoPowerBI
11 ай бұрын
😊thx!
@zahir585
5 ай бұрын
Brilliant ❤ thanks for sharing
@alicedwonderland7733
11 ай бұрын
Great video as always, Bas!! Also, is your beard shorter? :)
@HowtoPowerBI
11 ай бұрын
😅 yea slowly got shorter with every barber visit lol .. maybe i should grow it for christmas ;)
@alicedwonderland7733
11 ай бұрын
@@HowtoPowerBI grow it back - the channel would not be the same without a proper beard :) Also, make more PowerApps videos, please!
@gavinbroughton
11 ай бұрын
Brilliant
@HowtoPowerBI
11 ай бұрын
😊 thx!
@blueskyhunter3914
11 ай бұрын
This is very handy thank you!
@HowtoPowerBI
11 ай бұрын
😊 thx for watching
@danileyang
11 ай бұрын
"Why does the highlighting of metric values behave abnormally when I use an imported state dimension table? For instance, when in the second stage, it only highlights the corresponding second stage =dummy."
@habeebathabasumshaik5262
4 ай бұрын
I've tried this tracker but my progress bar is only highlighting the current status and not highlighting the finished statuses. Would you mind helping me with my issue?
@myskr-ds6qk
4 ай бұрын
SAME ISSUEEE
@habeebathabasumshaik5262
3 ай бұрын
@@myskr-ds6qk Found anything on that?😢
@kanishkvijaywargiya1340
11 ай бұрын
Impressive, I’ll try in my projects
@HowtoPowerBI
11 ай бұрын
awesome, have fun implementing it 👊😎
@florianboissiere6211
11 ай бұрын
Absolutely Genius!
@HowtoPowerBI
11 ай бұрын
😎👊
@Boopathy-xv2ti
9 ай бұрын
Can someone explain the last part (if condition) of the demo line Highlighy measure.
@myskr-ds6qk
4 ай бұрын
Why MAX function not working for me as it created 2 lines instead of one. now i have gray line & purple line
@saidiharun6948
11 ай бұрын
your are excellent and very creative.
@HowtoPowerBI
11 ай бұрын
Thank you so much 😀
@gilaniseye4267
10 ай бұрын
@HowtoPowerBI This is a great video, as always!😊 I downloaded the PBIX file and played a bit with the visual. As the purpose was to show a status with no interaction, using embedded SVG in DAX could be a relevant case for this scenario. Thus, I was able to reproduce the same visual with more advanced features like different circle sizing and checking only the right status. Watching your videos inspires me a lot in my Power BI developement. Again, thanks a lot for sharing your valuable knowledge. I really appreciated it Keep it up!!
@HowtoPowerBI
10 ай бұрын
thats awesome! 😎👊
@SandeepKumar19061900
9 ай бұрын
Hi Bas, please share the data in csv or xlsx format. I want to try this dashboard at my own. 🙂
@fermendizabal10
11 ай бұрын
Super interesting video! Where can I see or download the sample data used in the video??
@HowtoPowerBI
11 ай бұрын
download link is in the description of the video
@danishjameel6709
11 ай бұрын
I wish sometimes Bas was my neighbor. My power bi skills would have be an absolute beast
@HowtoPowerBI
11 ай бұрын
😂 I don't talk much about power bi with my neighbours to be honest .. just don't want you to get disappointed when you move into the house next to me 😉😁
@cindymary761
10 ай бұрын
Thanks for the video. In my own case i have 17 different client with different deal status stages, the disconnected table i created has all the different stages for all client so after adding the measure only the current stage was highlighted but i still have all the stages for all client making my x axis look rough. Is there a way that upon selecting a client name from my main data table let only the stages for that client from the disconnected table be visible?
@HowtoPowerBI
10 ай бұрын
you could write a filter measure and use that as a visual level filter to get rid of the stage that do not apply for a certain client
@prafulkapse23
10 ай бұрын
Many Thanks for the video. I am beginner in Power BI. This has helped me a lot. One problem I am facing, I am able to get the status but my line graph is not getting filled up till the status. It just Fills the color of the MARKER., does not fill the entire line. I already have spent 2 hours trying to figure it out. Kindly help !!
@majidgolnar7415
10 ай бұрын
I got the same issue. Have you found how to fix?
@maggiethinyane
9 ай бұрын
Same here, you figure it out?
@ghnwgfghnb
5 ай бұрын
I am facing the same issue
@myskr-ds6qk
4 ай бұрын
FACING THE SAME ISSUE, SOMEONE PLS HELP
@Eehonda_again
10 ай бұрын
This is a great idea and I tried to do this to display projects progression through project stages but unfortunately it showed every project as the last stage and I couldn’t fix it. Any wizards got ideas why it would do that?
@HowtoPowerBI
10 ай бұрын
maybe cross check with the file from the video? (see download link in description)
@Eehonda_again
10 ай бұрын
done and fixed =) thank you! @@HowtoPowerBI
@martin-i5l
11 ай бұрын
Is there any way to integrate chat gpt in our power bi report ?
@joseventura6843
10 ай бұрын
Can we add custom icons instead of checkmark?
@HowtoPowerBI
10 ай бұрын
any unichar works
@gopyjs6216
11 ай бұрын
Great stuff 👍
@HowtoPowerBI
11 ай бұрын
😊😎 thank you!
@mrutyunjayapradhan3599
11 ай бұрын
Next level 🔥
@HowtoPowerBI
11 ай бұрын
😎👊 thx
@user-bk8db7ud6k
11 ай бұрын
This is breaking my brain.
@HowtoPowerBI
10 ай бұрын
😂 hope your brain recovered over the weekend
@Westclox771
Ай бұрын
I followed the instructions and everything turned out awesome except the ✔ shows as ✔ Is there something I missed?
@kanishkvijaywargiya1340
11 ай бұрын
Is it possible to create a weather application using Power BI ?
@HowtoPowerBI
11 ай бұрын
pretty sure that's possible.. easier ask alexa though :p
@Wzxxx
11 ай бұрын
You are crazy man! Absolutely awesome and so creative! Great, thx! Love Ur channel!
@HowtoPowerBI
11 ай бұрын
Thank you so much for watching again!😀
@srinivasrakesh6887
10 ай бұрын
Hi can you please create any visual to show time and date in x&y axis
@HowtoPowerBI
10 ай бұрын
dates on y axis ? .. why would you want that?
@martinzipfel7843
9 ай бұрын
Great Video, I modified the formula to work for my use case however it is still very close to the original but I get a 1 for every status but the actual status of the shipment. Which makes the visual look a bit odd and I can't figure out why. Anyone got an idea? Dummy Line Highlight = VAR _Selected_Status = SELECTEDVALUE(Seafreight[Status]) VAR _Selected_Status_Nr = CALCULATE( Max(Code[Order]), Code[Status] = _Selected_Status ) VAR _Result = IF( SELECTEDVALUE(Seafreight[Status])
@venkatapraveenjannu4868
11 ай бұрын
Awesome..
@HowtoPowerBI
11 ай бұрын
Thanks 🤗
@juergh.hilgarth834
10 ай бұрын
Danke!
@HowtoPowerBI
10 ай бұрын
Thanks a lot for the support:):)
@arya4it
11 ай бұрын
Awesome
@HowtoPowerBI
11 ай бұрын
😎👊
@shivanandraskonda4670
8 ай бұрын
why to use the "_" start with variable name in power bi🤔
@HowtoPowerBI
8 ай бұрын
Makes it a bit easier when you are typing. You just enter a _ and it shows all defined variables
@sourabhpatel3834
11 ай бұрын
You can remove ✔️ from the stages which are yet to be complete!
@HowtoPowerBI
11 ай бұрын
yes you can 🙂
@syedyakub5849
11 ай бұрын
Bas, you are slowly changing the track from powerbi to front end UI developer 😂😂, I would suggest you to please keep an eye on data modelling and dax
@HowtoPowerBI
11 ай бұрын
got quite a bit of dax / power query videos as well
@piotrkuc8936
11 ай бұрын
I feel like the word 'Great' is so overused and lost its meaning. What should I say after watching this video? Saying Great is like saying nothing. ❤
@HowtoPowerBI
11 ай бұрын
😁 that's GREAT to hear thx ! 😉
@imxltf
11 ай бұрын
Thanks for the knowledge Master! Appreciate that!!
@HowtoPowerBI
11 ай бұрын
thanks! 😊
@smithabogar7422
Ай бұрын
Guys it works only when you change selected number dax from status table to main table( add order column in the main table )
@VarshithaV-x3p
10 күн бұрын
Hello Bas, Great Video also could you please share the data set used in this !
@JAYNEDOE_
2 ай бұрын
@1:38 New to DAX, I copied this word for work when creating a new table and received: “Column “Shipment Status” in table ‘Status’ cannot be found or may not be used in this expression. Any help?
@lppadua2047
10 ай бұрын
Bas, I made it. Thank you for this new visualization. I want to show you what I did but I can't paste it here. This is really amazing to use.
@alastairnaolu9372
11 ай бұрын
please continue to keep making videos! I love the real life application you provide with these builds.
@HowtoPowerBI
11 ай бұрын
definitely will
@aniketkengar3428
Ай бұрын
how can we use same stages verticaly
@mabl4367
11 ай бұрын
In my opinion, the checkmark measure should return an empty string for the non completed stages.
@HowtoPowerBI
11 ай бұрын
yea, was thinking about that one as well. I believe the web store I based it on had it like this - but its an easy edit
@filipef.6304
10 ай бұрын
Hey Bas, that was an AMAZING video, well done. Creativity jumped on a totally new level! :) But I have a serious question. I work as a Power BI developer, but this outcome made me confused. So, let's dive into: So I decided to recreate your solution. First, I created manually a "Shipment Data" with two columns -> Shiment Order and Shipment Status (no suprise). Then, I created a second table '"Status" with two columns (very important to note: I manually entered both columns). Then I started to built the chart. I put a dummy measure to create a line + Status Name on Y axis. Worked perfectly! Then I created a "Dummy Line Highlight" measure. And the magic happend. When I dropped "Dummy Line Highlight" measure on a chart only markers were colored (depending on status of course). Line remained grey does not matter what status of order was. I was thinking what I am doing wrong... I spent 30 min to figure out but I gave up and started everything from scratch. I decided to follow you as close as possible. And what happend? When I got to the point when I gave up before it started to work! Lines also had the right colors. So, where was the catch ? (It's only my thought) ->"Status[Order]" column is a calculated column (SWITCH function used) in your solution however I inserted this column manually, and that was the reason why solution did not work... To be honest I don't know why it happend? Any thoughts? Your help is highly appreciated especially if everyone else in your channel would also like to replicate this solution. Many thanks and keep it up!
@filipef.6304
10 ай бұрын
I did a further analysis and what I noticed, your solution stops working when (colored line), when next to Status[order] column is the duplicated column but entered manually. Once I deleted this manual column solution began to work properly. Any ideas, why it happens ?😢
@mrkenny83
9 ай бұрын
This same thing is happening to me.
@mrkenny83
9 ай бұрын
Using SWITCH instead of Power Query fixed it for me too!
@iliasseberrami3990
4 ай бұрын
in the line chart when i choose a product it highlight the marker with a different color but the line stays gray
@myskr-ds6qk
4 ай бұрын
SAME PROBLEM
@brandongillins
11 ай бұрын
I switched companies about a year ago and they only used tableau. I missed all your videos because you helped me shine like a rockstar! Now that company is moving back over to PowerBi. Time to binge? Most likely!
@HowtoPowerBI
11 ай бұрын
tableau is also nice though, why does the company switch?
@brandongillins
11 ай бұрын
@@HowtoPowerBI I got a promotion and different teams. I’m sure people will still use both but Power Bi excels at matrixes which many of my reports utilize. Or should say use to utilize.
@alfonsozalazar6960
11 ай бұрын
Excellent Video!! Do you think it is possible to create a flow chart with this approach? Because the free options in PBI marketplace are quite poor. Thanks for all the knowledge you share 🙌
@Rajeshkumar-f1f3z
11 ай бұрын
Hi Bas, is it possible to make a web service monitoring dashboard in power bi? Like showing the status of each selected service if its up or down as a graph within the selected range of time.
@timazarj9416
5 ай бұрын
Great as usual! Like to have a same tracking for client retention for membership, show the date that client renewed their membership as lable
@genivaldobonfimmachado3969
10 ай бұрын
Marvelous !! C9ngrat!! There is impossible to power BI?
@__HumanBeing
10 ай бұрын
Incredible. Just incredible. BAU with your videos.
@AbhiKeerti-q4j
Ай бұрын
its not working as u have shownnnnnnnnn
@HowtoPowerBI
Ай бұрын
Works for me
@AbhiKeerti-q4j
Ай бұрын
@@HowtoPowerBI it only highlights the status selected and not the previous ones like urs
@AbhiKeerti-q4j
Ай бұрын
@@HowtoPowerBI reply now
@yaxmokwa7612
7 ай бұрын
Coolest hack I have seen in long while.
@Gnouteetgnou
10 ай бұрын
Thank you Bas for this great lesson again! If you want to put the date on top of each round, can you do it with an additional measure? Thank you anyway!
@Gnouteetgnou
10 ай бұрын
I tried but I did get it, impossible to put the shipment Date on top! Which measure should I use ? Thanks for your great job and support!
Пікірлер: 227