Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi.
I have a table called journal and then I created a summarize table -> newTable = SUMMARIZECOLUMNS('journal'[TrackerID]; "StartTime"; MAX('journal'[StartTime]);"totalDuration"; SUM('journal'[DurationConnected]);"Outbound"; MAX('journal'[Outbound]);"PhoneNumber"; MAX('journal'[PhoneNumber])).
The new table gives me the amount of offered calls (as seen in graph below).
I get the amount of answered calls from the journal table (ordinary table with values):
How can I put these 2 charts in one clustered column chart?
Thanks for any support.
Solved! Go to Solution.
Hi @Anonymous,
Please refer to the steps below.
1. Your dates have time part. Since you don't analysis time here, we add a new column to tables [journal] and [newTable].
StartTimeNew = newTable[StartTime].[Date]
2. Create a date table.
Calendar = CALENDARAUTO()
3. Establish relationships.
4. Create the Table visual.
Best Regards,
Dale
Hi @Anonymous,
We need to establish relationships to connect these tables. It seems the Axis is [TrackerID]. I would suggest you create a table that is full of [TrackerID] then establish relationships among them. The final result is the Axis is 'New Table'[TrackerID].
Can you share a sample file? The solution could be more clear.
Best Regards,
Dale
Hi @Anonymous,
Please refer to the steps below.
1. Your dates have time part. Since you don't analysis time here, we add a new column to tables [journal] and [newTable].
StartTimeNew = newTable[StartTime].[Date]
2. Create a date table.
Calendar = CALENDARAUTO()
3. Establish relationships.
4. Create the Table visual.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |