Forum Discussion

Nazar's avatar
Nazar
Icon for Helper I rankHelper I
10 years ago
Solved

How to create chart with Column based on numeric data + 2 lines based on percentage

How to create such chart http://take.ms/yZd8A ?
there no percentage in data type http://take.ms/KyF5s


Here is data which I place into Power BI http://take.ms/csjhN

When I create chart and sort by Nice it starts to look like on Excel, but only columns. http://take.ms/hhSXn http://take.ms/Tbqhh When I add line values they move to top by single straight line, not like on that example from excel http://take.ms/jRkUN
 

Even I simply create 100%stacked column chart
http://take.ms/dgoLX

  • Nazar Whenever you don't have the option to SUM and you see only COUNT - your data is DATA TYPE - TEXT

    So go and change the Data Type for the 2 Line Value Columns

4 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion

    Nazar Line Values - change to SUM - not COUNT

     

     

    also turn on the secondary axis (when you open up the Y-Axis there will be a scroll bar (scroll down)

    This should hopefully fix it. Let me know.

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion

        Nazar Whenever you don't have the option to SUM and you see only COUNT - your data is DATA TYPE - TEXT

        So go and change the Data Type for the 2 Line Value Columns