Having a summary row at the bottom of the table.

[pyaesonekhin]

I am having troubling visualization my data to a matrix table. My table contains date, time, tickets and capacity. I used matrix table to show where row: time, col: date and values: sum of sold. And this is what i get.

However, I also want to show capacity, available and available (%). Available and availabe (%) can be calculated using DEX but i cannot show it like the format I want. Am i missing something here?

Format that I want:

	22-Nov	23-Nov
11:00 AM	2	3
12:00 AM	2	3
13:00 PM	1	2
Total	5	8
Capacity	10	10
Available	5	2

[rohit1991]

I have created a few steps, hope this helps :

• Create calculated measures for Capacity, Available, and Available (%). These will calculate and display the required values dynamically.

• Build the matrix table:

  • Add Time to Rows.
  • Add Date to Columns.
  • Add the following fields to the Values section in this order: Sold (Tickets), Capacity, Available, and Available (%).

• Enable measures to appear as rows:

  • Go to the matrix visual’s settings in Power BI.
  • Turn on the "Show on Rows" option in the Values pane.
  • This will show your measures as separate rows under each time slot.

• Handle totals for percentages. Ensure totals are correctly summarized by summing the numerator and denominator separately before dividing.

• Format the matrix:

  • Format the Available (%) field as a percentage in the formatting options.
  • Adjust column width and font size to make the visualization clearer.
  • Apply conditional formatting if needed to highlight specific values.

• Double-check layout and data to ensure all measures are displayed in the proper order and the data reflects the desired breakdown of Time, Date, Sold, Capacity, and Available.

[pyaesonekhin · Accepted solution]

Thanks for the help. Currently, I see this format when I turn on "switch value to row".