Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
I am newer to Power Bi and I am building a one page report. I have 4 tables. These four tables have the exact same column names that obtain similiar data.
Like this-
Tables Bugs Stories Tasks Work Items
All the tables contain these columns Area Path, Assigned to, Iteration Path, State, Title, Work Item Id, Work Item Type
The ask is to only have 1 page and they would like to filter by bugs stories tasks and work item tables.
How would I go upon connecting those to develop a slicer on my page?
Thank you!
Solved! Go to Solution.
Hi @Anonymous.
I'm curious why you have four tables with the exact same structure. In Power Query you could append those four tables into a single table and then this would be simple.
Or you could create additional tables in DAX.
DISTINCT(
UNION(
Table1[Bugs],
Table2[Bugs],
Table3[Bugs],
Table4[Bugs]
)
)
Repeat as appropriate for Stories.
DAX UNION does not eliminate duplicates like SQL does so including the DISTINCT function will eliminate them. Once created, create a relationship between the new Bugs table and Bugs column in each of the four tables (and the same with Stories). And finally create slicers using the fields from the new Bugs and Slicers tables.
Hope this helps!
@Anonymous you're welcome, glad I could help.
you could really simplify the whole thing by appending those four tables into a single table... 😉
Hi @Anonymous how'd this work?
Hi @Anonymous.
I'm curious why you have four tables with the exact same structure. In Power Query you could append those four tables into a single table and then this would be simple.
Or you could create additional tables in DAX.
DISTINCT(
UNION(
Table1[Bugs],
Table2[Bugs],
Table3[Bugs],
Table4[Bugs]
)
)
Repeat as appropriate for Stories.
DAX UNION does not eliminate duplicates like SQL does so including the DISTINCT function will eliminate them. Once created, create a relationship between the new Bugs table and Bugs column in each of the four tables (and the same with Stories). And finally create slicers using the fields from the new Bugs and Slicers tables.
Hope this helps!
Thank you! This worked.
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |