Forum Discussion

skancharla's avatar
skancharla
Advocate II
9 years ago

Dual Y axis in Line chart

Hi,   I'm working on a line chart and displaying 2 columns Project count and test count. Project count is in tens of number and test count in thousands.With a single Y axis ,the Project line almost...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I can't agree more. Power BI is meant for finding trends in data etc, how are you meant to find a trend if you can't compare 2 different types of data??

 

I spoke to Power BI and they said I could go to one of their partners and pay them to make a custom visualisation for me. If I am paying this much for Power BI, shouldn't I expect it would do something simple as this (look at how google charts does it, its simple as and you can add more than 2).

 

The way to implement this (especially more than 2) would be to have the name and values in the y axis for which ever line you hover over.

  • GenoRockMdt's avatar
    GenoRockMdt
    Frequent Visitor
    7 years ago

    Not sure when it was added but the Line and Clustered Column Chart visual has the ability to define 2 Y axes. 

    Seems to work as expected when I show all my data unfiltered.

    When I apply certain filter values, the left Y axis disappears... Apparently, there are some values that don't compute somehow for the axis.  I did some troubleshooting and determined that the left y axis in my case is for the lines and 2 of the line series values rely on DAX Percentile function. I tried to capture any error condition on the dax formula so it now looks like:

    P90Value = IFERROR(PERCENTILE.INC(tx_vEvents[eKpiNotifyAge],.9) , 0 )

    But the Y axis still disappears under certain (but not all) filters.

    Please advise Microsoft - thanks!