How to Build a Native Quadrant Chart in Power BI

Подписаться 70 тыс.

Просмотров 22 тыс.

50% 1

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

Наука

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

2 года назад

Impressive tutorial. Thanks.

@sonalipanchbhai5189 7 месяцев назад

Very Helpful Content. Thanks.

@datafoe626 2 года назад

Awesome. Please keep up the good work!

@BIElite 2 года назад

Thanks, will do!

@sonetmollick4630 2 года назад

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

@BIElite 2 года назад

Great to hear!

@jrazafindrabe5229 2 года назад

My Goodness, this is Simple and Amazing.

@BIElite 2 года назад

Hahah glad you thing so

@abhishekstatus_7 2 года назад

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

@BIElite 2 года назад

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

@abhishekstatus_7 2 года назад

@@BIElite You are welcome!!

@HachiAdachi 2 года назад

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 2 года назад

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 2 года назад

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

@datafoe626 2 года назад

You're the best!

@BIElite 2 года назад

You're too kind 😊

@pritammusale7858 2 года назад

Excellent 👏👏👏

@BIElite 2 года назад

Thanks Pritam!

@robrayborn1349 2 года назад

Very clever!

@BIElite 2 года назад

Thanks Rob!

@lucadelicio9883 Год назад

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

@shashirajusiddaraju4979 2 года назад

Awesome!!

@NEHAYADAV-do1gd 2 года назад

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

@chescov 2 года назад

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

@BIElite 2 года назад

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

@MrMsaisankar 2 года назад

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

@ask416 6 месяцев назад

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

@ZoeyLu 2 года назад

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 RU-vid!

@antique-bs8bb 2 года назад

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 2 года назад

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 2 года назад

@@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 2 года назад

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

@antique-bs8bb 2 года назад

@@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 2 года назад

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