Export Report Summarized Data Does not Contain 0 Values

[SEMattis]

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.

[v-easonf-msft]

Hi , @SEMattis 

Not vey clear what happend.

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

Check if "show item with no data" is checked

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

Best Regards,
Community Support Team _ Eason

[SEMattis]

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 :).

.

[v-easonf-msft · Accepted solution]

Hi ， @SEMattis 

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

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

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.