Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi all,
Is it possible to produce a table as follows, using a TABLE (not Matrix)?
Key goals are:
- Alternating row colours that span ALL columns (matrix doesn't seem to do this)
- Status column at end of table with conditional formatting to change icon colour (matrix doesn't seem to support this)
- Dynamically grouped column headers by year (matrix supports, but need this in table for above reasons).
Kind regards,
Ben.
Consider using other tools for this, like Excel.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |