Forum Discussion
Bar Chart Showing blank month
I am looking to do a monthly bar chart but for some reason when I create a relationship the month data is blank.
I have set up fiscal year/fiscal months. I created a relationship between meeting date and my fiscal calendar with a "many to one" relationship. The data is coming from a SharePoint List. So far there should only be data for November and it is my fiscal starting month. However the month comes up as blank when I create the relationship. Essentially people are putting a meeting date into a SharePoint List and I want to show how many meetings per month are being held.
The SharePoint List data is formatted to display a Date and Time but came into Power BI as Text. I have formatted that field in Power Query to show up as a date. Is there something I am missing?
Thanks
Hi SRL
According to the information, although you have successfully created a one-to-many relationship between the two dates, the dates are not matched correctly.
Please check whether the date formats of the dates in the two tables are the same, and then make sure that when you convert the date format in Power Query, the date writing format is consistent with the writing format of your calendar table.
If the above solutions cannot solve your problem, can you provide some of your sample data or some pictures (please hide your private information) so that we can provide you with a better solution?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi SRL
According to the information, although you have successfully created a one-to-many relationship between the two dates, the dates are not matched correctly.
Please check whether the date formats of the dates in the two tables are the same, and then make sure that when you convert the date format in Power Query, the date writing format is consistent with the writing format of your calendar table.
If the above solutions cannot solve your problem, can you provide some of your sample data or some pictures (please hide your private information) so that we can provide you with a better solution?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Thanks, I needed to parse out the date to get the format correct.
