Combo Chart in Power BI with multiple Y axis

[Shahinkmajeed]

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.

Thanks in advance!!

[luxpbi · Accepted solution]

Hi @Shahinkmajeed,

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

Regards,

[Seward12533 · Accepted solution]

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. “

[luxpbi · Accepted solution]

Hi @Shahinkmajeed,

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

Regards,

[Seward12533]

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. 

[Shahinkmajeed]

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

[Seward12533]

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

[Seward12533]

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.

[Seward12533 · Accepted solution]

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. “

[Shahinkmajeed · Accepted solution]

Thank You So Much Seward. It works!!!

Regards,

Shahin K