- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Including a zero value period in Line chart calculated via Measure
Hi Guys,
I've created a line Chart by using two measures:
Blue line
Green line
The line chart result is as follows:
How can I make sure the blue line which has a value of ZERO in P5 is pulled through?
Is that possible with a measure?
I know that some things unfortunately aren't possible with Measures in PowerBI.
Thank you!!!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Your issue is that the count function returns null instead of 0 if there are no values. So, you need to modify your formula with an IF statement to allow it to return 0 when the count is 0. The formula is below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi nsexton12,
Thank you very much for your help. I will try the advised formula for my learning process.
I literally just sorted the issue slightly differently:
NEW formula Blue line:
Keep learning.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi nsexton12,
Thank you very much for your help. I will try the advised formula for my learning process.
I literally just sorted the issue slightly differently:
NEW formula Blue line:
Keep learning.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Nice! There are always many ways to solve each problem. Could you please mark my reply as a solution if it worked for you?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes, It did work. Took a little longer as I'm new to PBI and tried to apply it to my situation.
Thank you!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Your issue is that the count function returns null instead of 0 if there are no values. So, you need to modify your formula with an IF statement to allow it to return 0 when the count is 0. The formula is below.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-24-2024 12:31 AM | |||
Anonymous
| 06-27-2024 04:26 AM | ||
07-30-2024 12:17 PM | |||
01-02-2024 08:44 PM | |||
01-01-2024 01:58 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |