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
cnsrvative
New Member

Y axis issue on combined graph in PowerBI Report (web)

I have created 4 charts utilizing data syncing from Excel tables.  The tables for the 4 reports are identical (the first table was used to format and initially the other 3 via copy/paste).  The reports were generated in PowerBI reports after data import.  In the charts, the column values are percentages (0%-100%) and the line values are numbers (0-XXX).  

 

I created the first report to appear how I wanted it, then I duplicated the report and replaced the data with the data from the other 3 tables.  This resulted in 4 reports based on the 4 tables.  The first 3 reports function as intended and designed.  They utilize the SLA% as the Y axis on the left and show values 0-100%.  The alternate Y axis on the right is for the line data and has the values 0-XXX.  The X axis is dates, and functions correctly in all 4 reports.

 

In the 4th report, the Y axis on the right scales from 9-1000% and there is no right axis.  You will see the difference this makes in the appearance of the chart.  There is no % value above 100%.  Additonally, in the Y axis settings, I only have the Linear setting, not the Log setting.  The other 3 charts have Log as an option. I have read posts concerning zeroes and negative numbers removing the Log option, however, there are zeroes in all 4 data sets and the 4th chart is the only one that exhibits this behavior.

 

Although the chart was initially duplicated from the first chart, I deleted it and recreated from scratch in order to rule out any issues with the duplication process.  I receive the same result.  I removed the initial table and recreated it to rule out issues with the table, and again, I received the same result.  I am unable to determine the cause of this behavior.  While the chart works, it appears so different from the others as to cause question and concern amongst others viewing the data.

 

Attached are samples below of the charts and the associated tables.  Looking for any insight into why this 4th chart might be acting the way it is.2020-05-05 09_04_54-Presentation1 - PowerPoint.png

 

1 ACCEPTED SOLUTION
mihart
Employee
Employee

Hi @cnsrvative 

Let's start with the simple solutions (you've probably already tried these):

  1. You're sure that you've turned on the second Y axis? (Show Secondary is ON)
  2. Secondary Y axis is set to start at 0 and end at "Auto"
  3. all charts are same type of combo chart
  4.  all are formatted to start at zero and end at "Auto"
  5. You've played around with the Axis settings for both Y axes
  6. Clear the error fields -- maybe the errors are messing things up?

If none of these suggestions work (especialy #1), let me know.  Maybe you can share the Excel data?

Thanks

Michele

View solution in original post

2 REPLIES 2
mihart
Employee
Employee

Hi @cnsrvative 

Let's start with the simple solutions (you've probably already tried these):

  1. You're sure that you've turned on the second Y axis? (Show Secondary is ON)
  2. Secondary Y axis is set to start at 0 and end at "Auto"
  3. all charts are same type of combo chart
  4.  all are formatted to start at zero and end at "Auto"
  5. You've played around with the Axis settings for both Y axes
  6. Clear the error fields -- maybe the errors are messing things up?

If none of these suggestions work (especialy #1), let me know.  Maybe you can share the Excel data?

Thanks

Michele

Second set of eyes and all that - completely overlooked the secondary axis trigger.  Many thanks for the time!

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

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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

Top Solution Authors
Top Kudoed Authors