Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm new to Power BI, and I'm encountering a challenge when creating multiple relationships in my dashboard. Here's the scenario:
New Requirement:
Question:
I'm unsure how to proceed. How can I enable the new table's slicers to filter data across all cards in my dashboard?
Thank you for your input @ikesil . I initially tried creating a Calendar table and establishing a relationship with it to ensure accurate counts on my dashboard. However, I encountered an issue because I had already established a relationship with the Date column using the Calendar table. Now, I'm trying to incorporate another table containing additional columns for which I want to create slicers. Since I already have a relationship with the Calendar table, I can't establish another one. I attempted to resolve this by creating a bridge table and placing all the slicer data there, connecting it to the Fact table. However, this approach only affected the data for the Fact table card, leaving the data for other table cards unchanged. Do you have any alternative solutions that might address this challenge? Your insights would be greatly appreciated. Thank you in advance.
If all your relationship use a date as the connecting column, it would probably be a good idea to create a calendar table. This table would let you set 1 to many relationships to the rest of the tables, removing all those many to many relationships.
Creating a simple calendar table is as easy as using this formula after selecting the "New Table" option in the Modeling menu (you can make more complex calendars by adding more columns or conditions):
calendar = CALENDAR(date(2024,01,01), today())
Once you do that it should be a lot easier to create new tables and relationships.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |