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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Export should remove 0 values.

I have added +0 at the end of the measure to fix the x axis. Chart is showing the x axis values where value is 0 its working fine to me.
But the client requirement is while exporting the chart data in csv file it should remove the 0 values or filterout the values from the export.

Is it possible in power bi to handle or any functionality to show only on graph but not in export?

1 REPLY 1
danextian
Super User
Super User

Hi @Anonymous,

 

I  do not think that is currely possible. The export file is either what the visual looks like ( for matrices) or the underlying data.  My suggestion would be to use field parameters so the visual can toggle between [measure] + 0 or just the plain measure. It is an additional step but can be a workaround.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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