SUPER Useful VISUAL for Better DECISION-MAKING I Dynamic QUADRANT ANALYSIS in Power BI
Вставка
- Опубліковано 23 лип 2024
- In this video I show you how to create a dynamic quadrant chart using reference lines connected to what if parameters in combination with conditional formatting. The result is: a super useful visual that results in better decision-making. Enjoy the video and subscribe for more Power BI hacks!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
00:37 Creating a scatter plot with constant lines
02:10 Most important in the top right quadrant
02:39 Creating what-if parameters and slicers
04:34 Linking the constant lines to the slicers
05:22 Adding conditional formatting to the data colors
09:34 Customizing the conditional formatting rule
12:34 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on UA-cam: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - Наука та технологія
As I get more proficient on PowerBI, the quality of your content impresses me even more. This is such a great lesson, thank you
It brings me immense pleasure watching these magic tricks.
This is awesome Bus, really thanx for this video!
You are brilliant. This is a great example of what can be done and so well explained. Thank you!
thank you so much Ian! that's really nice to hear 😀
Making the Quadrant chart so much useful ! Thanks bas 🙏🏼
This is just perfect for what I needed to do! Thank you, Bas!
Glad it was helpful! thx for watching Barbara 😀
Love your work Bas! Super clean and clever tricks 👏🏼👏🏼👏🏼
thanks for watching Luis! 😀
love this , inspire me a lot to build more effective visualize
Great work - really elegant!
Fantastic video Bas, a great combination of feature, loads to take away from this
Amazing! I love recreating your tutorials. I'm learning a lot. ❤
Awesome, Glad you like them!
It blowed my mind! Nice video!
Super useful video indeed!!! Rare kind of "one visual worth thousand words", makes visual to "shout" to report users :) (and report author shine). Great work Bas, enjoy your tips and tricks.
So useful! Thanks!
VERY nice! this is very useful. Very well explained, must try this one. Thanks so much Bas!
thank you!!! 😀 yes - those constant lines are not as boring as the name suggests 😁 many useful applications
another cracking video, Bas. These dynamic constant lines are useful as hell.
I'm loving them! 😀 thx Dion
Hello amazing video, really love it !
However, do you think this can work with the back ground of the visual instead of the bubbles ?
Thanks for sharing advice.
Great video , thanks 👏
Very cool on the parameters - I thinking instead of putting the quadrants as values (1, 2 etc), you could have put them as the hex colors themselves. Then instead of putting the 4 rules in the conditional formatting, you can just put it as the value of the measure.
I know have done that on some conditional formatting before on table backgrounds, not sure it will work with scatter plot (feel it should).
Cool! Do you also have a trick to color the areas of the quadrant dynamically? As in right above is green left, below is red with changing constant lines?
Brilliant, thanks a lot, Bas!
Glad you liked it! thx for watching Lana 😀
Great job, Bas!
This is a really helpful video! Is there a way to make a scatter plot table/chart with the x and y axis being non numerical?
Amazing!
Very good as usual, Bas !!!
thank you so much João!!! 😀
Thanks for your wonderful content. Little help from you, Is there a way to adjust the thickness of constant line to halfway or show half of lines or based on the paeameters? If yes, hope you can cover this on your next content. Thank you.
This video is very helpful. I was able to solve a problem in my office
Happy to hear it helped Karthikediga!
🔥🔥🔥 Thanks!
Thanks Bus. This is next level
thank you Sudhir!!! 😀 great to hear
Love your bro amazing
👍 great
Thanks
Am a PBI novice user. Found this video to be immensely helpful. How do you extract the quadrant analysis as a table in you report?
Awesome !!!
Thanks Sedat!
Hey is it also possible to color the background of the different quadrants you have created?
I have a situation like this, for calculating MoM and WoW, I need to consider same period in the previous year. Let's say if I want to return MoM for August 2021, then calculation would be like (Aug_2021 sales - Aug_2020 sales)/Aug_2020 sales * 100. Like this it should be dynamic for MoM and WoW and in the view I need to display like Last 12 months for MoM % growth, and Last 13 months for WoW % growth. I achieved the calculation but not able to restrict last 12 months/13 weeks. Any help on this would be helpful.
Note: we are not supposed to use calendar table as per our requirement. So considering sales_date from data itself and I achieved WoW and MoM based on month_number and Week_Number. And based on maximum sales_date, we need to display last 12 months or Last 13 weeks.
Cual es la diferencia entre usar esta habilidad vs clúster ( dinamic o personalizado) ?
How do you come up with them? Amazing content, man!
This is gold!
Glad you think so Alin :) Thanks!
Great tricks
Hi Bas, how is it possible that the centered x-axis value (in your case 100) is always displayed?
I have the problem that if I change my setting through slicer that the centered x-axis values, may not appear every time.
Thanks!
Amazing work Bas and team! Making my work so much more productive!😃
Quick question for anyone: Is there a way to calculate dynamically the 'sales' or other measures for each quadrant? Could be Very helpful in this type of analysis to place a card with this info next to the main graph.
Given that the conditions return True/False its complicated building the DAX code. I would appreciate your help a lot!
Really want to know the answer to this too!
Me too!
Hi Bas,
Great Video! I recently implemented the conditional formatting to our customer profitability analysis. One question I had during the process:
Do you know if its by now possible to change the background color based on the conditions? So having a highlighted background for the top right quadrant for example.
I saw this apporach on some blogs who disucss and explain the use of a scatterplot for a customer profitability analysis and im curious if this is already achievable in PowerBI.
Thanks for you videos!
BR Frederik
At the time of writing, I believe the only thing you can do to the plot area background is use an image - which obviously isn’t dynamic
Is there any method to show the quadrant text like Q1,Q2 and so on
Amaaaaazing
thx Mostafa!!!! 😀👊
Thank you. 👍, when to use conditional formatting based on rules versus field value?
you could also define the color in the measure itself (instead of 1,2,3,4 - "blue","green","red","blue") .. Then you would use field value - I would do it like that when I apply the same conditional formatting rule to other visuals, because then when you want to change the colors or rule you do it in the measure it updates nicely everywhere.
@@HowtoPowerBI Thank you 👍
Good one!
Thank you Osura! Cheers!
@@HowtoPowerBI I used this for one of my reports recently. Great trick!!
Hey Bas, see if you could help me with a scatter chart:
My client want...
In X:dates
In the dots: the number of all results he get in any days with lab analyses.
There are an average of 12 analyses made in a day and I need to show all the 12 dots in each date.
I think a Line Chart jus with markers solves it, but I'm screwed!
Sorry for my poor english 'cuz i'm brazillian.
Super Content. Trying to solve my problem using it but Quick question, I don't see Function (fx) option next to my Value textbox in x-axis constant line. Would appreciate your help.
you are on an older version of power bi that doesnt have it yet. you would need to update power bi
Valeu!
wow thank you, thank you, thank you!
How can we get a diagonal line in a scatter plot
Hi
I have an issue like,
if row information is there anywhere in the other column then that is true, so display the 3rd-row info
if not I need to display any text like "Completed"
any thoughts?
Note:- All these are in a single table
Hi, I would like to see complete dynamics RLS based on region, country and entity level for my data model, top level having full access and then cascading down other regions
Hi Bas, may I ask a question? If I applied a slicer to the quadrant, then the Constant Line will be changed according to the slicer. So why does it happen? Thanks.
Sir... Ur my hero and role model....keep the good work... May God bless u
You are god!!!
How do I remove outliers? Or scale the view appropriately ?
You can set the axis min max using a measure, so could set limits that way - just be done it the opposite way by increasing the axis to 110% of max value to create more space. Or group the values and filter out what you don’t want on the visual
When im writing the measure, i cant fint my axises VAR Targetxxx = ‘AxisName’
Amazing. Can you also explain dynamic Bubble Chart and it conditional slicer coloring in ESG Analysis Report - by Ellicium Solutions Pvt.Ltd
looks like it is just adding the field sector on legend
Bloom tnt brain 🧨 🧠 thanks 🙏🏻
Could you please enlarge the presentation screen? Loved your tutorial but I find the shared screen too small!
Glad you liked it! Thanks for the feedback :)
How to name each quadrants based on their properties?
nice 👍 Wonder where did you get your DAX hoodie?
DIY… :) you want one?
@@HowtoPowerBI yes!
11:55 achoo achoo
Just some constructive criticism, don't take it personally: but people are here for Power BI, not your face. Why does it need to take up the majority of the screen?
Bro you are definitely the best
Thanks a lot for your videos 🫡🫡🫡