The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |