Forum Discussion
Line chart
Hello Pravallika-gadd , thank you for sharing a question with the Community. This reply is informational. Please follow the decorum of the Community Forum when asking a question.
Please share your work-in-progress Power BI Desktop file (with sensitive information removed) and any source files in Excel format that fully address your issue or question in a usable format (not as a screenshot). You can upload these files to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then provide the file's URL.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you. Proud to be a Super User!
Thank you , for solution but I don't have calender table am taking the shipdate column from delivery table same shipdate only am using in the formula for current year and previous year
Has the problem been solved? If it's solved, share your solution and accept it as a solution, which will help members of the community who have the same problem as you find a solution faster.
If not, please share your data.I would be grateful if you could provide me with the pbix file or sample data.Remember to remove sensitive data .
If you have any other questions please feel free to contact me.
Best Regards,
Leroy Lu
