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.
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.
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.
Helpful resources
Fabric Community Update - November 2024
Find out what's new and trending in the Fabric Community.
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Be one of the first to start using Fabric Databases
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
