How to Build a Native Quadrant Chart in Power BI

In this Power BI tutorial, I show you how to build a quadrant chart for quadrant analysis natively within Power BI. You won't need to use a custom visual or any 3rd party tools, just the native Scatter Chart and a little bit of DAX! Quadrant charts are helpful to divide your data into four areas for analysis. Recently Power BI released functionality for dynamic X and Y Axis lines, making a true quadrant chart possible!
To enroll in my introductory or advanced Power BI courses:
training.bielite.com/
Blog Post/PBIX Download:
bielite.com/blog/native-quadr...
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Connect with me on Twitter!
/ powerbielite
0:00 Intro
2:05 How to Build the Quadrant Chart
8:55 Alternate Form
11:05 Outro

Impressive tutorial. Thanks.

[@sonalipanchbhai5189]

Very Helpful Content. Thanks.

[@lucadelicio9883]

Hi thank you very much for the content. There is the possibility to apply different color to the quadrant background? Thank you!

[@sonetmollick4630]

Awesome. I will definitely use this technique in my report.

[@BIElite]

Great to hear!

[@abhishekstatus_7]

This is super awesome Parker !! Thanks to you ! You always bring some innovation in Power BI for us !! Thanks a ton again!

[@BIElite]

No problem, Abhishek! Always happy to see your comments on my videos.

[@abhishekstatus_7]

@@BIElite You are welcome!!

[@datafoe626]

Awesome. Please keep up the good work!

[@BIElite]

Thanks, will do!

[@jrazafindrabe5229]

My Goodness, this is Simple and Amazing.

[@BIElite]

Hahah glad you thing so

[@HachiAdachi]

Very nice, Parker! In order to keep the constant lines in the center, I guess you could alternatively adjust the min/max of each axis and still use the average values for the constants. I love the recent addition of conditional formatting options for axis and constants!

[@BIElite]

Hey Hachi! Yeah that's a great idea. I guess some outliers wouldn't be included in the selection, but that sounds like a feature (not a bug) lol

[@HachiAdachi]

You can still include the outliers and keep the constants in the center by setting the axis min/max dynamically based on the dataset, right? Whether that's a good idea is another topic, I guess. Lol

[@NEHAYADAV-do1gd]

AMAZING!! how to count the number of ratings per quadrant ?

[@ask416]

Unfortunately I don't see the constant line in the scatter chart in Power BI anymore.

[@shashirajusiddaraju4979]

Awesome!!

[@chescov]

This was an amazing example! Thank you very much! May I ask how/where the dataset was downloaded from?

[@BIElite]

Yes! You can find it here: www.kaggle.com/stefanoleone992/rotten-tomatoes-movies-and-critic-reviews-dataset

[@MrMsaisankar]

Thank you for the great video, however the coloring part is not working for me as the average value and the point value and the point level is the same. so the color coding is not happening. How to over come this?

[@verified_user]

I am facing the same problem

[@datafoe626]

You're the best!

[@BIElite]

You're too kind 😊

[@pritammusale7858]

Excellent 👏👏👏

[@BIElite]

Thanks Pritam!

[@robrayborn1349]

Very clever!

[@BIElite]

Thanks Rob!

[@ZoeyLu]

You might want to check with Google about their algorithms in calculating your "like" counts for your videos. I just clicked on like as the 212th person. However, after I refresh the video, it did not record my like and it went back to 211. Something is messed up with TH-cam!

[@antique-bs8bb]

Hi. Very good
I am wondering:
Average X = AVERAGEX(ALLSELECTED(Data), Data[tomatometer_rating])
Why not just AVERAGE( Data[tomatometer_rating])
What does ALLSELECTED(Data) do?
I tried it and the colors don't work, but I'd like to understand why.
Even though when I put both cards on the screen both versions consistently show the same number

[@BIElite]

All good questions. Thinking back on it, I used AVERAGEX because I was trying to do something else at first. You could also write it as CALCULATE(AVG(Data[tomatometer_rating]), ALLSELECTED(Data)).
ALLSELECTED tells your calculation to consider all points within your visual, not just the specific point that's being used for the calculation. That's a pretty simple explanation, though it's a bit more complicated.
There could be many reasons why your colors aren't working. Have you tried downloading the PBIX file to see the logic?

[@antique-bs8bb]

@@BIElite
Yes. The vertical lines worked fine with Average. But the Quadrant Color measure didn't. All the dots were black.
The measure Average X gets reused as a VAR in Quadrant Color:
VAR AverageXValue = [Average X]
So we need ALLSELECTED for the 2nd time the measure is used, not the first time
I was comparing a single dot (row) with the average of that same single dot.
Where as I really needed all the rows selected in that visual - hence, obviously, the need for ALLSELECTED !!
A nice learning experience

[@bencramer11]

@@antique-bs8bb I'm also having the same issue did you ever figure it out?

[@antique-bs8bb]

@@bencramer11 The answer is simply that you have to use Average X = AVERAGEX(ALLSELECTED(Data), Data[tomatometer_rating]))
just as the video says. The conversation is about "why". It is complicated...

[@bencramer11]

@@antique-bs8bb I did that and it still didn’t work.