Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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

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.Data_Exported_from_Default_matrix_visual.pngDefault-Matrix-Design.png

Frequent Visitor

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. 



Frequent Visitor

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.


Frequent Visitor

Turn off column subtotals.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors