Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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

Syndicated - Outbound

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