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

Combo Chart in Power BI with multiple Y axis

Dear All,

 

I am a beginner in Power BI. I have a requirement to create a line chart with multiple Y axis as below. Also please note that the the X axis values have to come in the descending order. Kindly help.

 

image.png

 

Thanks in advance!!

3 ACCEPTED SOLUTIONS

Accepted Solutions
luxpbi Helper V
Helper V

Re: Combo Chart in Power BI with multiple Y axis

Hi @Shahinkmajeed,

 

Here you can find how to put 2 y-axis in a line chart in Power BI. 

 

Regards,

 

View solution in original post

Seward12533 Solution Sage
Solution Sage

Re: Combo Chart in Power BI with multiple Y axis

FYI reported this on ideas forum and got this answer.

“In your scenario, you need to change the X-Axis type as Categorical, then the sort menu is available if the X axis has date or number values. “

View solution in original post

Highlighted
Shahinkmajeed Helper I
Helper I

Re: Combo Chart in Power BI with multiple Y axis

Thank You So Much Seward. It works!!!

 

 

Regards,

Shahin K

View solution in original post

7 REPLIES 7
Seward12533 Solution Sage
Solution Sage

Re: Combo Chart in Power BI with multiple Y axis

If you click the ... menu that appears in the top right corner of the visual you will see the sort options where you can choose Ascending. 

luxpbi Helper V
Helper V

Re: Combo Chart in Power BI with multiple Y axis

Hi @Shahinkmajeed,

 

Here you can find how to put 2 y-axis in a line chart in Power BI. 

 

Regards,

 

View solution in original post

Shahinkmajeed Helper I
Helper I

Re: Combo Chart in Power BI with multiple Y axis

Hi Dear, I cannot see the sort option in the menu option. 

 

image.png

Seward12533 Solution Sage
Solution Sage

Re: Combo Chart in Power BI with multiple Y axis

Where are you X Values coming from? Do you have a date tabble

Seward12533 Solution Sage
Solution Sage

Re: Combo Chart in Power BI with multiple Y axis

I think you may have found a BUG with the new Sort Capability they recently rolled out. I have to try to find an old powerbi install to test it.

 

When you have an integer series on the axis it does not let you sort! Also would not sort with Date[Date] on the axis I even tried specifying Sort by and choosing the date field.  It did work with a text column in the date table that had Sort By used to specify the sort (in this case sort by [Date] column.

 

 As a work around I added a "Last N Days" from NOW to my date table, added a second column for [Last N Days TXT] using FORMAT([Last N Days,"General Number") and set a visual filter on that to limit chart to last 21 days and the used the actual date on the axis. Could then sort just fine.

 

See this sample PBIX I modified form another solution I recently helped out on as an example.

 

capture20180807173803930.png

 

 

 

Seward12533 Solution Sage
Solution Sage

Re: Combo Chart in Power BI with multiple Y axis

FYI reported this on ideas forum and got this answer.

“In your scenario, you need to change the X-Axis type as Categorical, then the sort menu is available if the X axis has date or number values. “

View solution in original post

Highlighted
Shahinkmajeed Helper I
Helper I

Re: Combo Chart in Power BI with multiple Y axis

Thank You So Much Seward. It works!!!

 

 

Regards,

Shahin K

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors