cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Export Report Summarized Data Does not Contain 0 Values

Hi,

 

I have created a Power BI report containing a Matrix in which all values, including "0" values, are visible. However, when exporting the data I cannot export the data point containing the 0 values. Can someone support in how to get these values exported using the "Export Data" function using the Visualisation.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi , @SEMattis 

In Excel or in  Csv?
Check whether you have applied any filter in you visualization.

43.png

You also can  check it from the Excel file your have exported.

 

42.png

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Hi , @SEMattis 

Not vey clear what happend.

If you  click "show as a table", are data points containing 0 values invisible?

39.png

Check if "show item with no data" is checked

40.png

 

 

If you still have the problem, please share a simple sample pbix file for us have a test.

 

Best Regards,
Community Support Team _ Eason

Highlighted

Hej,

@v-easonf-msft 

 

No it is not when looking at the data in the table view or in the visualisation itself. It is when I am trying to export it using the "Export data" option in the Visualisation Menu ("..." Option). When I clic the Export data option only values that a greater than 0 or less than 0 are being exported. But I want to include the 0 values in the export. 

 

Do not know whether my explanation has made you any wiser, but thank you for your support so far :).

 

.Crop.png

Highlighted

Hi , @SEMattis 

In Excel or in  Csv?
Check whether you have applied any filter in you visualization.

43.png

You also can  check it from the Excel file your have exported.

 

42.png

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors