Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
PhilMart
New Member

Export to PDF and Matrix Visual causing problem since last month

Hi all

 

Hoping someone can steer me in the right direction.

 

I have a matrix visual showing customers along with the values sold, cost, margins etc.  In prior months (I print end of month reports), I could Export to PDF and the information would display correctly in the PDF. As of printing today (24/1/2023), when exporting to PDF and reviewing the results it appears that the names of the customer are not related to the value sold etc. It appears that all customers have been moved up and the top four customers removed.

 

Example only (sorry)

 

On screen

 

Customer 1   10000

Customer 2     5000

Customer 3     4000

Customer 4     3000

Customer 5     2000

 

On PDF that displays after export (and in viewing in Acrobat Reader)

 

Customer 5   10000

Customer 6     5000

Customer 7     4000

Customer 8     3000

Customer 9     2000

 

So to reiterate, the information is showing in the matrix in the Power BI Desktop correctly. It is only when exporting to PDF that I get the top four customers removed and replaced with those further down the list. I have tried closing the app, refreshing the app with no success. Only appears to be Matrix visual, as I have Table visual which looks to display correctly.

 

 

 

4 REPLIES 4
Basil_Job
New Member

I have another problem with this pdf converter, since 2nd of October 2023, it prints pdf with default value only even if we ask it to print the current value.

I had faced similar problem during Sep 2022 ,then MS confirm the problem and conveyed that the problem was due to some bug in the then latest upgrade to the pbi.

Later after 10 to 15 days the problem was solved .

Can any one help me with some solution for this issue.

ribisht17
Super User
Super User

@PhilMart,

 

Difficult to say withour report sample although there is one similar post here

https://community.powerbi.com/t5/Service/Export-PDF-Matrix-issue/m-p/759145

 

Regards,

Ritesh

This is from the Power BI Desktop, so it appears to be something related to conversion to PDF for matrix visual.

 

Another thing is that I show all customers and simply print the top 20 odd (as displayed on the screen). The rest do not need to be printed. 

 

Also always printed OK for last three years, but only recently has changed.

 

Will test with new PBIX and see if I can duplicate so I can post that with scrubbed data!

I have replicated in a sample PBIX using excel data and will post to the issues part of the forum when I can. Thanks for looking. 

 

For anyone that wants to know I think it is about having a certain number of records in the matrix visual. In my first case I had only 25 customers and all worked OK but then added 1000 customers and started getting the problem

 

PhilMart_0-1674527408333.png

PBIX

 

PhilMart_1-1674527459372.png

PDF

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors