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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Yagevendra
Helper IV
Helper IV

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 @Yagevendra,

 

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.










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


Proud to be a Super User!









"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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.