Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Export should remove 0 values.
08-23-2022
10:40 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022
11:06 PM

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
Recommendations
Subject | Author | Posted | |
---|---|---|---|
10-08-2024 04:24 PM | |||
09-02-2024 05:29 AM | |||
02-14-2024 02:38 PM | |||
04-22-2024 06:54 AM | |||
05-06-2024 03:02 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
114 | |
92 | |
84 | |
54 | |
46 |