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...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

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
5 years ago

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
    5 years ago

    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!