Forum Discussion

PowerBINew's avatar
PowerBINew
New Member
8 years ago

Line and Stacked column Chart

Hi All 

 

I have a Line and Stacked Column chart to display two sets values. 

 

In X-axis I have time from Jan 2018 to June 2018 and in the line value I have the a projected values that is achieving projecting how to achieve the target of 1000 over 18 months time so it's moving upwards over the time. 

 

I want to show the Actual commulative values for each month in the columns so that i can show the progress if the values are under the line it means we are not meeting the target but If its touching the line or crossing the line we are on right track. 

 

When I put actual value in the Column value field the columns are way bigger than the line value. 

Please see the attached image . I want the columns values correspond with the line values.

Could you please to solve the issue ?

 

8 Replies

    • PowerBINew's avatar
      PowerBINew
      New Member
      8 years ago

      Hi Ashish 

       

      Thanks for replying back. I new to PowerBI and It's asks me for the Pro lincense to share the file that I don't have. 

       

       

      The follwoing table contains the Data I am using for the graph. 

       

       

       

       

      Please let me know if it helps.

       

      I want to achieve the following results :

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Upload the file to Google Drive/OneDrive and share the download link here.