Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm new to Power BI. Appreciate any help on this! I have three tables and the relationship among the tables was established through the Date(text type/eg:2022 Q1) and region (text type/eg: North Central etc) columns. I have two slicers on a page - one for date and another for region. It was working fine until I added a new table to it. The new table has data since 2023 Q1 and now the Region slicer lists the regions only for the date slicer value '2023 Q1'. If any date (eg: 2022 Q1,2022 Q2,2022 Q3...) is chosen other than '2023 Q1' in the Date Slicer, the region slicer is blank.
Date - ID, Date
Region - ID, Region
Table 1 - Date, Region, Total Clients, Sales A
Table 2 - Date, Region, Total Clients, Sales B
Table 3 - Date, Region, Total Clients, Sales C
Table 4 -Date, Region, Total Clients, Sales D
Table1,2,3,4 : Region many to one
Table1,2,3,4 : Date many to one
Hope this information helps! Thank you!!
Hi @DK_Sree
It seems like the issue is with the relationship between the tables. You can try the following steps to resolve the issue:
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.