cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Quadrant Chart and Scatter Chart NOT showing Y axis values as expected

My E1000 Measure is not displaying correctly on the Quadrant Chart.  

E1000 = ( Divide([Usage_ED], [Attribution_PersonYears], 0 ) ) * 1000
 
Here is the Data Showing on the Table, however the Y axis on the Quadrant chart is showing more/less division of roughly 100.  If I click on the individual PCP (Line# Individually), the value for the Y axis shows correctly (1010 versus 102 when no PCP is selected)
 
PCP      Attribution PY    Usage      Users    E1000      Matrix showing
Line 1 (Green)453     458      274     1010     102
Line 3 (Yellow)33733020298083
Line 2 (Black)43037322486874

 

Here is the picture of the Quadrant Chart.  Scatter chart is doing the same thing.  What am I doing wrong?

 

QuadrantChart2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: Quadrant Chart and Scatter Chart NOT showing Y axis values as expected

GO FIGURE!  When I changed the PCP Name back to "Full Name" instead of Line 1, Line 2, Line 3, etc., the quadrant worked as expected.  It must have been a hiccup with Power BI 😮

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Quadrant Chart and Scatter Chart NOT showing Y axis values as expected

Hi @vstopp ,

 

I am not sure what desired result would you want. When you click PCP Line 1, what should the returned Y axis value be?

 

Best Regards,

Amy

 

Highlighted
Helper I
Helper I

Re: Quadrant Chart and Scatter Chart NOT showing Y axis values as expected

Currently Line 1 is showing 102.  When I click PCP Line 1, the quadrant shows 1010 (the desired result)

Highlighted
Helper I
Helper I

Re: Quadrant Chart and Scatter Chart NOT showing Y axis values as expected

PS.  The grand total for the E1000 is 748

Highlighted
Helper I
Helper I

Re: Quadrant Chart and Scatter Chart NOT showing Y axis values as expected

GO FIGURE!  When I changed the PCP Name back to "Full Name" instead of Line 1, Line 2, Line 3, etc., the quadrant worked as expected.  It must have been a hiccup with Power BI 😮

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors