Line and Stacked Column Chart with 2 line and bar chart

[Anonymous]

 

I have Line and Stacked column chart with two lines (Y axis )of different data types as shown in pic,  
When I add Sum ID to chart and enable Seconday Y Axis - it sticks to X axis. Primary Y axis have % F (bar) and % achievment (line)  where as Secondary Y has SumID (line)

I want % achievment(line)  to be showed as per it's values on primary Y axis . How ???

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

After my research, I'm afraid it couldn't achieve in Power BI for now.

As a workaround, you may try to keep % F  and % achievment in Line value and SumID in Column value.

Best Regards,

Lin

[Anonymous]

Thank You for the answer   , I rearranged coumn and line values. In Excel it is pretty straight forward

[v-lili6-msft]

hi, @Anonymous 

It's pleasant that your problem has been solved, could you please mark the reply as Answered?

Best Regards,

Lin