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

Quantities added when cells Blank (waterfall table)
11-02-2021
01:05 PM
Hi,
I am working on a waterfall table to show forecast changes MoM, however in the cells that are blank, a value is populating (see screenshot below). How do I remove this? I want these cells to be blank.
Appreciate any help!
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-05-2021
12:17 AM

How do you create waterfall table? It's difficult to understand your scenario without information.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-02-2021
08:35 PM

@Anonymous , need to check your formula for that. This seems something is getting added
Like [value] + 44197
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
11-27-2023 11:47 AM | |||
02-16-2024 10:05 AM | |||
Anonymous
| 10-28-2019 01:45 AM | ||
08-05-2024 12:53 PM | |||
04-19-2024 01:46 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
137 | |
107 | |
84 | |
59 | |
46 |