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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.