UNLEASH Hidden INSIGHTS | Data COMPARISONS in Power BI REIMAGINED

[@WesleyYappy-n1m]

1) 1:17 - create filter for categories and "Baseline", empty 2) 4:31 - define filter for categories and create filter for baseline 3) 7:54 - define what is the baseline

[@hi55us2]

The king of Power BI has returned! Such great content!

[@HowtoPowerBI]

Thanks a lot! Glad you like it :)

[@HowtoPowerBI]

I didnt know I went away though :p

[@hi55us2]

Didn't mean to imply you left, you just keep coming out with great videos!

[@geirberge8971]

this is just so beautiful. so applicable in many contexts. now we're talking black belt. thank you

[@matthewdufty606]

The Doctor is In!

[@PildorasBI]

Great Job! I am an Spanish User and your videos are really useful!🎉😊

[@bradbear]

Great work! This is a great technique that could be used for so many thing. Kudos! I’m sure your design course is epic.

[@HowtoPowerBI]

Thanks for watching Brad! 😎

[@shahinshahin7742]

​@@HowtoPowerBI😊

[@wilconagtzaam587]

Brad, I can totally advise taking that course. Best I have had on Dashboard Design!!

[@alicedwonderland7733]

@@wilconagtzaam587 just checked out the price - while it's worth it for sure, it's way too much for me :(

[@arbazahmad7177]

This one is absolutely great 👍... Thanks

[@W8LL13]

Hi Bas @HowtoPowerBI, Love the content. I've got a similar question that I just can't get right in Power BI, similar to this baseline use-case. Let's say I want to reference my KPI's (or KPI values) to a certain reference period. So for instance, between january 1st 2022 and march 31rd 2022 (Q1 2022), this was let's say a *golden* period, which is like the benchmark period. How do I create a structure (table and measures) in Power BI, that compares a user data-input selection (for instance Q2 2023, but also Q1 2021) to compare with the reference period selection. E.G.: Q1 2022 (reference period): Sales amount = €1.000.000 Q2 2023 (user selected period): Sales amount = €1.120.000 (+ 12% ) I would then want to display the difference in certain metric KPI's between the reference period and the user selected period. Is this possible?

[@juanignacioXI]

Another great piece of art and geniality Bas, thanks a lot!

[@HowtoPowerBI]

Thanks for watching and you kind words, means a lot 😎

[@Banksiana]

This seems like a good forum to ask this question if it ever gets seen. I'm looking to create a button on Power BI that looks like it is being pressed down. I've figured out as far as using shadows to create a raised feel to the button but I'm struggling to make it such that when the shadow disappears upon hover or upon press it looks as though the button has moved to being in a pressed down position. Anyone have any idea how to do this? The problem I'm currently running into is that when I remove the shadow, the button simply reverts to the normal flat shape when I really want it to keep its same shape but move down (or deeper into the page if that makes sense) without a shadow.

[@roywilson9580]

Very useful and interesting video, thanks for taking the time to post.

[@HowtoPowerBI]

Super welcome :):) 😎 thx for watching

[@alicedwonderland7733]

I got it! Bas, you're so clever!

[@unnikrishnansanthosh]

hats off to BAS, thank you for sharing

[@PhilcoCup]

This looks a lot like comparative analysis from Qlikview . Nice implementation master Bas! Always a pleasure watching your videos man, first thing I did out of bed today!

[@HowtoPowerBI]

Super good morning then !!! :)

[@karinamatvejeva3164]

There are so many good word. Nothing to add. Just 🔥🔥🔥and Thanks!!!!

[@HowtoPowerBI]

🙌thankyou!

[@marekklucka4407]

Great job. I believe that could be even extended with calculation groups so the user can always check the specific aggregation as plain average is not always wanted. I was thinking about something like this just recently, you read my mind.

[@abel9]

Thank you for this video ! My customer asked me to do something similar, and i used the disconnected dimension technique, but the main problem is that he doesn't want to have 2 separated dimension for the same attribute (ex : channel name) but to have two different attributes named channel name x and channel name y into the same dimension table. If you have a solution to that, it's could be great. Thank you for your great work !

[@grytskokonstantin1272]

Great work, Bas ! Thanks a lot !

[@HowtoPowerBI]

Glad you like it!

[@virajphadnis]

Very useful as always, will surely implement this in my next project. Thanks a lot Bas.

[@furtunahab4441]

You always amaze me with your creativity, I have questions if you can help I installed Getaway to refresh the data but it keeps asking me to change my password every 30 days how can I address this issue from keep changing my password all the time? Thank you.

[@edwinarchico439]

This will help in my proj, very useful , thanks a lot Bas🎉

[@HowtoPowerBI]

Glad to hear this Edwin :)

[@subhashg6856]

Very useful tip. Thanks for sharing

[@zammam5509]

Hey Bas Thank you for this excellent video cn u plz guid freshers more about powerBI

[@mr.admiral15]

Bas is the Boss ! Thank you for this

[@shubhamrai9316]

I'd like to inquire about a method to add an image to a table visual sourced from either an Excel file or a SharePoint site. I need this image to dynamically change based on filter selections. However, the crucial requirement is that the image should appear in a round shape rather than the default square shape. Currently, when I add the image using its URL, it displays in a square shape. Any guidance on achieving a round-shaped image in the table visual would be greatly appreciated. Thank you!

[@SiriusScientist]

This is great! How would you modify the baseline slicer to exclude any selections from the visualization slicer? For example, the way I could use this is a comparative to a target and I wouldn’t want the target for change (checked item or items in the visual slicer) included in the baseline comparative data. I guess you could also just add in a context tab or in the tutorial for using the report, but it would be cool to have it “error proof” and a little pop up if hovering explaining why you can or can’t select certain slicers. Great tutorial as always!

[@CrossSo]

„Hello, my Name is Boss“ sounds right 😅 …another great idea with practical use!

[@KroLeXz]

Thank you, this gave me ideas for another solution! ❤

[@HowtoPowerBI]

:) awesome! 😎

Thank you so much Bas, that helps me a lot!!!

[@HowtoPowerBI]

Happy to help Matheus!

[@julieliggett3825]

Can this method still apply if we want to give users the ability to select different fields for the baseline - for example, if they want to compare results from a promotion to a baseline of total product category, or total product business unit etc?

[@marekklucka4407]

That would require a little bit more of magic, but can be achievable. I believe that instead of distinctvalue in the table you can actually use then field parameters. Or you can always use good ol' SWITCH magic with disconnected tables, but that would be a lot maintenance heavy.

[@sebastianjerezansaldo2069]

Very practical and easy to replicate. How can I set the right panel to hide the data and visualizations with the small icons?

[@SupernovaSmith]

I am struggling to troubleshoot why my baseline doesn't remain when I use the "SHOW" slicer. The Baseline shows when nothing is selected, but as soon as I select an item it disappears.

[@500iq6foot8]

Can you do a video on how to get line charts to scale better so when a person filters onto a selection where there is little variability overtime it doesn’t zoom in so much that it makes little changes look like big changes

[@viz-xp8dd]

Keep doing what you doing boss

[@HowtoPowerBI]

Thanks, will do!

[@josefedericopresno6668]

Very useful. Thanks a lot, Bas.

[@HowtoPowerBI]

Glad it was helpful!

[@VictorHugo-sy2tq]

Great work!! I have a question: why did you change the cardinality to One to many? I thought one to one was always the best option.

[@adilumr6359]

For the others to flow

[@SM23Studio]

very good technique, thanks!

[@HowtoPowerBI]

Glad it was helpful!

[@dineshmalluddeniya180]

Thanks Bro... Supper..

[@HowtoPowerBI]

So nice of you

[@DinaraMak]

interesting! could you please create something showing revenue difference between some line and base line, e.q. atual rates and billing rates.

[@geirberge8971]

Takk!

[@HowtoPowerBI]

Thank you :):)

[@oricchannel2811]

Hi, Bas. Great work. Is the sample pbix available for download ?

[@HowtoPowerBI]

thanks a lot! :) should be there now

[@oricchannel2811]

@@HowtoPowerBI Thank you !!! I learned a lot from this video, as well as from the other videos on your channel.

[@GuyOrlov]

When do you think this video will open for subtitles on? I am Deaf I really want to watch this video with subtitles, I hope KZbin generates this option very soon.

[@HowtoPowerBI]

I've added the subtitles :)

[@GuyOrlov]

🎉 thank you

[@HikimaruL2]

Very nice !

[@HowtoPowerBI]

Thx for watching

[@nishanth4323]

Hi Bas...🙂🙏

[@HowtoPowerBI]

Hey hey! 😎

[@nishanth4323]

@@HowtoPowerBI ✌️😉

[@cognosboss9411]

Why did the basline tag change to "Other" at the end?

[@HowtoPowerBI]

I called it other instead of baseline in the solution file.. just thought baseline was a better description

[@jobinthefoodie]

Awesome!!!!

[@HowtoPowerBI]

Thank you! Cheers!

[@In_a_state]

These exaggerated titles lead to being let down when I see what the clip actually refers to. :(

[@HowtoPowerBI]

Sorry to hear that

[@gshooting2]

What did you think it would refer to?

[@graymccarthy685]

@BluDreamboy You’re not getting the elegant sophistication of what Baz just showed you

[@AIdevel]

The Irish

[@RubenCarlosCalderonValladares]

Very nice!!

[@gregoryoliveira8358]

Wow. Great!