Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Solved! Go to Solution.
Thanks for the help. Currently, I see this format when I turn on "switch value to row".
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:
Enable measures to appear as rows:
Handle totals for percentages. Ensure totals are correctly summarized by summing the numerator and denominator separately before dividing.
Format the matrix:
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.
Thanks for the help. Currently, I see this format when I turn on "switch value to row".
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |