Forum Discussion
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-msftCommunity Support
Hi Craig3TCE ,
Could you pls provide your .pbix file for test?Remember to remove the confidential information.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- v-kelly-msftCommunity Support
Hi Craig3TCE ,
Is your issue solved now?If not,could you pls check my last reply?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- Craig3TCEFrequent 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-msftCommunity 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,
KellyDid I answer your question? Mark my post as a solution!