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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Blank Chart In Powerpoint Export

I have a multi-page report I'm trying to export to a PowerPoint but the only column chart in the entire report isn't showing up correctly in the exported PPT file. It shows up fine both in Desktop and in the online Workspace, but then something weird happens to it on export.

 

Here's the chart in the PowerBI file:

Capture.PNG

 

But when I try to export it, it goes blank and the X-axis has -28800000 as it's starting point.

Capture2.PNG

 

The X-Axis is a simple calculated column in my data set that shows what day of the month it is: DAY(Table[Date). It's a whole number, as well. Any idea why this might be happening? Only issue I have with the export.

1 ACCEPTED SOLUTION

Hi @Anonymous 

This sounds like a bug to me.  

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

View solution in original post

5 REPLIES 5
mihart
Employee
Employee

Hi @Anonymous 

This is a very new feature and still has a long list of considerations and limitations.

Have you checked this doc: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-powerpoint

DO any of these apply to your situation?

Take care,

Michele

 

 

Anonymous
Not applicable

Hi, Michele. I looked over the document you linked to and the visual doesn't look like it should be limited for any reason. The visual is the standard Stacked Column Chart, one of the default visualizations. There are slicers and filters affecting the image, and the document you linked to said the export would preserve them. None of them are URL-based filters that can't be exported per the link.

 

However, when I did go to check the filters, it doesn't look like the Power BI service is saving them correctly. The visual in question is only supposed to show the most recent month of data, so I put a filter on the month to show The Top N (1) Month by number. However, when I save the report and switch to "Reading View" to export it, it changes the Top N to "All."

 

Here's what it should look like (During edit mode):

Capture.PNG

 

 

 

 

 

 

 

 

However, this is what it looks like after I switch to "Reading View":

Capture2.PNGCapture3.PNG

 

 

 

 

 

 

As you can see, the value increases to include all months, not just the single one like before. It looks like there might be an issue with how filters drive the visual during the export process? When I tried to use the "Copy visual as image" feature as a possible workaround, it gave me the same blank chart as before layered on top of what looked to be the code that drives the visual. It's the only visual in my report so I don't have anything else to check it against.

 

Hope this is helpful in some way!

 

 

HI @Anonymous,

Where did this fields stored, raw table, or related tables? If you mean stored in other table with a relationship, how did you relationship setting? If you filter wiht other feilds, did this issue fixed?
Please share more detailed information to help us clarify and reproduce your scenario.

How to Get Your Question Answered Quickly 

Regards,

XIaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

The filters don't seem to the be the issue, as when I try to export it using the "Export to PDF" function in Power BI Desktop instead, it works just fine. This looks like an issue with the Power BI online service only. I've tried to alter the filters, but it still comes up with a similar error. The fields come from a data table and then a created calendar table, with the date table directly related to it via the date column in the data table.

Hi @Anonymous 

This sounds like a bug to me.  

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors