Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi PowerBi Community,
I have a many tables and relationships, but to summarize my problem -
Table A
Object | Date | Ct |
A | 1-Jan | 5 |
A | 3-Jan | 10 |
A | 5-Jan | 15 |
B | 2-Jan | 1 |
B | 5-Jan | 2 |
B | 7-Jan | 3 |
Table B
Object | Date | Status |
A | 1-Jan | 1 |
A | 2-Jan | 1 |
A | 3-Jan | 0 |
A | 4-Jan | 0 |
A | 5-Jan | 1 |
B | 2-Jan | 1 |
B | 3-Jan | 1 |
B | 4-Jan | 1 |
B | 5-Jan | 1 |
B | 6-Jan | 0 |
B | 7-Jan | 0 |
the dates here will always
- be on a daily level
- have the start and end date according to the min and max date in table A according to each object
Table A and B have a relationship based on object column -
I have two visualizations, for table A and B, and the goal for me is to ensure both display for the same timeperiod.
NOTE: there are a few other slicers on the visual as well, which I would like to keep as is.
I have tried a few different approaches but none of them have worked out for me 😞
- I have tried to add an intermediate date dimension table. This filters the both visuals on the correct dates, but then I am not able to pull the count of status for the correct objects.
- I have tried to use SELECTEDVALUES, VALUES, ALLEXCEPT but none of them have yielded correct results for me.
Any help with this is much appreciated! Thank you in advance!
@Anonymous Are those tables related and if so on what column?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
70 | |
63 | |
55 | |
48 | |
46 |