Forum Discussion
Helper VRelationship between Calendar Dimension and Facts Table
Helper VHello,
I'm sorry for the delay, my concern is when the user filters the date or when I use the month in the chart as a dimension, I don't want to show all dates from the calendar dimension, I would like to show only the dates existing in the facts tables in the filter and the charts as a dimension
After I did the link between the Fact and calendar table, I imagine using the field Column of dcalendar table as a dimension in my charts and filters correct? However, now I have the wrong result because it is showing dates that I don't have in my fact table.
I already did this, I created a column called Column, to link with the Month field in Fact Table. The Column has the same format, 01/MM/YYYY
Community SupportHi twister8889
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
- twister8889
Here is my pbix: https://1drv.ms/u/s!AoDYwrtLrltJn1ZVfsxyNY2jirsg?e=H7daVp
Reminder: I need to have a filter with Date (01/MM/YYYY) only with dates in my facts table. In my pbix I have four "fact table", with a Month column, and these other tables need to link with Custom in the dcalendar table.