Forum Discussion
Visualization Line charts start with 1st work day
Hello,
I have gotten my 1st task in Power BI to create some simple excel report in Power BI. It is a simple chart that shows count of applications that are compared vs previous and 2 months ago. But in excel they have it that in the line charts start to show the data from the 1st work day and they overlap nicely.
As I am very new to Power BI, could you please tell me what is the solution or keywords that I need to look for to find out how to force the visualization to start from the 1st working day?
2 Replies
v-xicaiCommunity Support
Hi Anonymous ,
I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.
You may use following DAX to get Weekday column.
Weekday= WEEKDAY(DateDim[Date],2)
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.