Forum Discussion
EXCEL LIKE TABLE
Hi, is possible to build this in power bi
Anonymous ,
One option which you have to use is "Show on row", that will move your measures on the row.
Other you can follow
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
HI Anonymous,
I think matrix visual should similar to your snapshot, but it does not support setting column header to display on each subcategory row. Create matrix visualizations in Power BI
For color formatting, you can take a look at conditional formatting features. (notice: row/column header and total level not able to apply color formatting) Use conditional formatting in tables
Regards,
Xiaoxin Sheng