Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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
Hej,
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 :).
.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.