topic Default MATRIX Visual Export In Excel Option Not Showing Data accurately in Design Level in Custom Visuals Development Discussion

Default MATRIX Visual Export In Excel Option Not Showing Data accurately in Design Level

Baqa — Tue, 11 Jul 2023 12:46:27 GMT

I created a custom Matrix Visual to meet my design requirements. Unfortunately, when I exported it to Excel, the formatting was affected and did not transfer properly. I had intentionally left some rows blank in the visual, but they appeared in Excel. Additionally, disabling the expand and collapse mode to achieve a specific design was also unsuccessful. Furthermore, the color theme did not transfer correctly. I'm seeking assistance in reformatting the export to resolve these issues.

Re: Default MATRIX Visual Export In Excel Option Not Showing Data accurately in Design Level

Ena — Tue, 11 Jul 2023 15:58:53 GMT

Did you use the Filter pane to hide the Totals field? If yes, that might be the issue. It might be hidden in view but not turned off. Rather, turn off totals under Visualizations pane.

Re: Default MATRIX Visual Export In Excel Option Not Showing Data accurately in Design Level

Baqa — Wed, 12 Jul 2023 04:38:51 GMT

I used dax to show blank data for specific rows. And I disable show items with no data for that particular item to hide blank rows which is achived perfectly. Upon exporting the hidden rows appears. I havent turned on totals under Visualizations pane. I am calcualting it by using dax.

Re: Default MATRIX Visual Export In Excel Option Not Showing Data accurately in Design Level

Ena — Wed, 12 Jul 2023 13:13:13 GMT

Turn off column subtotals.