Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a clustered column chart with summarize table

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'[D...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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.

    Create-a-clustered-column-chart-with-summarize-table

    4. Create the Table visual.

    Create-a-clustered-column-chart-with-summarize-table2

     

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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.

    Create-a-clustered-column-chart-with-summarize-table

    4. Create the Table visual.

    Create-a-clustered-column-chart-with-summarize-table2

     

     

    Best Regards,
    Dale