Forum Discussion

Craig3TCE's avatar
Craig3TCE
Frequent Visitor
5 years ago

Line chart with years stacked

Good morning all,

 

I'm trying to create the following -

This was created in Excel.

 

I have 2 columns from Direct query, date and balance.

 

I'm able to achieve the following -

I got to this by adding the Date Hierarchy from a date table into the axis, Year into the legend and balance into values and then drilling down to day level.

When I remove Year from the axis, I get the following -

Is there a way to achieve the original Excel line chart in Power BI?

 

Many thanks, Craig

4 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support

    Hi Craig3TCE ,

     

    Could you pls provide your .pbix file for test?Remember to remove the confidential information.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support

    Hi  Craig3TCE ,

     

    Is your issue solved now?If not,could you pls check my last reply?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

    • Craig3TCE's avatar
      Craig3TCE
      Frequent Visitor

      Hi Kelly, apologies it's not my dataset, it's from a colleague. I'm waiting for a stripped back version to come through without any confidential data.

       

      We're using Direct Query - if I upload the PBIX, it will have to be an imprted dataset - will this affect the report? From my experience, dates can act very differently on an imported dataset vs. Direct Query.

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support

        Hi  Craig3TCE ,

         

        Apologies for the late reply.

        Yes,it would be different,I dont have the access your dq mode dataset,pls share me an imported one.

         

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!