Reply
pdlv
Helper I
Helper I
Partially syndicated - Outbound

Export data problem

When i tried to Export data through Filter with empty data filtered in scatter chart

pdlv_0-1721189963272.png

The output file is contain not only column of table but also the X, Y-axis constant line column.

pdlv_0-1721190389017.png

 

Can It only show the 3 column that like when it have data?

pdlv_2-1721190330410.png

 

1 ACCEPTED SOLUTION

Syndicated - Outbound

Hi @pdlv 

There is No constant line in the table: This feature is specifically designed for graphs for comparison purposes.

Data that is exported to Excel is in table form: There is no connection to the filter status. What is displayed in the visualization at the column level is what will be exported to Excel.

This is why I created 2 visualizations: For examining data relationships, there is a graph with a constant line.

For a data table that is supposed to be exported to Excel, there is no constant line. We have no option to manipulate what is exported to Excel other than choosing "export current layout " of table.

The export graph displays all columns participating in the graph, including the constant line if it is a part of the graph, no matter what acrobatics we perform.
This is not a filters and values issue, it is a function of which fields you put on the visual.
PS
It is unclear why one would want to export an empty table to Excel....

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
Ritaf1983
Super User
Super User

Syndicated - Outbound

Hi @pdlv 
Unfortunately no, when you are exporting graphs all the data of the query is there.
You can add the table/matrix visual with needed columns only for exporting and allow the user to switch between them with the bookmark before exporting.
Something like :

Ritaf1983_0-1721191743075.png

Ritaf1983_1-1721191774524.png

Guide to switch visuals here :
https://www.youtube.com/watch?v=cFZtUzABOa8&t=57s

pbix with my example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Syndicated - Outbound

Thanks for your reply, but my problem is when it have no data and I export, it contain the redundant column

Export like this

pdlv_0-1721199428440.png

on the file it redundant the "Count of Values"

pdlv_1-1721199503081.png

 

Syndicated - Outbound

Hi @pdlv 

As I mentioned, this is how it works with graphs.

If you export the table you'll get only the columns visible at the table...with or without values.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Syndicated - Outbound

Can u try my situation? Please, add Constant Line with value is the column then filter to make chart empty, then export

Syndicated - Outbound

Hi @pdlv 

There is No constant line in the table: This feature is specifically designed for graphs for comparison purposes.

Data that is exported to Excel is in table form: There is no connection to the filter status. What is displayed in the visualization at the column level is what will be exported to Excel.

This is why I created 2 visualizations: For examining data relationships, there is a graph with a constant line.

For a data table that is supposed to be exported to Excel, there is no constant line. We have no option to manipulate what is exported to Excel other than choosing "export current layout " of table.

The export graph displays all columns participating in the graph, including the constant line if it is a part of the graph, no matter what acrobatics we perform.
This is not a filters and values issue, it is a function of which fields you put on the visual.
PS
It is unclear why one would want to export an empty table to Excel....

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)