Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Devi2211
New Member

Conditional Scatter Chart by dividing the X and Y axis to 4 Quadrants

Hi,

 

I am trying to generate a Scatter Chart based on some conditions that divide the chartt into 4 Quardents.

I am suceessfuly generated this reprot  in Excel but unable to generate in Power BI.

Please find the SC of the same,

 

From Excel:-

 

FromExcel.png

From Power BI:-

FromPowerBI.png

Thank you.

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

Hi @Devi2211,

In Power BI Desktop, the Scatter Chart doesn’t include quadrants. To work around this issue, you can use ggplot to create Scatter Chart with quadrants, there is a similar thread for your reference.

Another option is to create Scatter Chart in Excel and then pin the chart to Power BI Service dashboard following the guide in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-pin-a-tile-to-a-dashboard-from-exc... .

In addition, an idea about showing quadrants in Scatter Chart has been submitted in the following link, you can vote it up.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15058437-ability-to-show-quadrant...

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

Hi @Devi2211,

In Power BI Desktop, the Scatter Chart doesn’t include quadrants. To work around this issue, you can use ggplot to create Scatter Chart with quadrants, there is a similar thread for your reference.

Another option is to create Scatter Chart in Excel and then pin the chart to Power BI Service dashboard following the guide in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-pin-a-tile-to-a-dashboard-from-exc... .

In addition, an idea about showing quadrants in Scatter Chart has been submitted in the following link, you can vote it up.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15058437-ability-to-show-quadrant...

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you @Lydia Zhang

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors