Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Together,
i hope someone of you could help me 😃
Is it possible to combine mutiple rows from differen Excel- Sources ??
I would like to combine the date from several sources in one. The background is that I want to make a graphic for each source but all change as soon as you change something on the timeline.
Greeting Sven 😃
Solved! Go to Solution.
You need to create a date table, a dimension table (DimDates).
Link the DateKey of this table with the date field of the other tables. Use Datekey to filter all the tables at once.
There are several ways to create a date table. Logically the best is in M. Anyway I'll pass this link.
http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Marco G
You need to create a date table, a dimension table (DimDates).
Link the DateKey of this table with the date field of the other tables. Use Datekey to filter all the tables at once.
There are several ways to create a date table. Logically the best is in M. Anyway I'll pass this link.
http://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Marco G
Hi SvenMaassen, the request is a bit vague.
If you can kindly insert some more data or an example of the current situation and the desired one.
Marco
Hey Marco,
sure no problem!
i have these 3 Excel Sources
Now i want to get just One Timeline where every Graph changes. BEcause every Source have an row with Dates. And for example want to see how each "Graph/Source" was last year.
I dont want to make several timelines for that 😄
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |