Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I am trying to export matrix report in excel. It is keeping the hireacrchies same in export however some rows I intentionally keep blank in matrix not exporting properly. In BI UI row is blank whihc is handled through dax. But in export the total is written in the column.
And another issue is the rows in matrix which are in hirearchy when exported in excel they are in two differnet column whihch is making layout diffent from matirx in BI to in excel.
Is there any workaorund to keep the rows in matrix in single column for exporting in excel so the layout remains sam e.