cancel
Showing results for
Did you mean:
Regular Visitor

## Data table with missing date ranges - how to visualize 0s?

Hi guys! Having a bit of trouble with what I thought would be a simple, common requirement.

I've got a data table that looks something like this:

Shipment Date is the date that the item was shipped, Shipment Week is Shipment Date rounded to the previous sunday. My visuals are on an itemnumber-by-itemnumber & week-by-week basis.

My red < lines show periods where entire weeks have no shipments. When I visualize this in a line graph, what I'd like is for that to show as 0, because 0 of that item shipped that week. What it does instead is it draws a continuous line from the weeks with data, like so:

So yeah, where the red v's are is where there is no shipments for that week. Naturally I'd like to see that go down to 0 rather than show a continuous line.

Do you guys have any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Data table with missing date ranges - how to visualize 0s?

My point of view , what u r trying to show that is not possible is this chart or visuals in power BI default chart.

Next,

1. if u measure is calculated column , add one if condtion like

Measure = IF ( Isblank( sum(Column_Name)), 0 , sum(Column_Name) )

try this, let me know

6 REPLIES 6
Super Contributor

## Re: Data table with missing date ranges - how to visualize 0s?

Cool dude,

1. Without data how can we show as 0.

2. If want to show missing date in X-Axis , we can do , choose "Continuos" in X-Axis Property pls refer image

Regular Visitor

## Re: Data table with missing date ranges - how to visualize 0s?

Thanks man, but it's already set to 'continuous'

Super Contributor

## Re: Data table with missing date ranges - how to visualize 0s?

My point of view , what u r trying to show that is not possible is this chart or visuals in power BI default chart.

Next,

1. if u measure is calculated column , add one if condtion like

Measure = IF ( Isblank( sum(Column_Name)), 0 , sum(Column_Name) )

try this, let me know

Regular Visitor

## Re: Data table with missing date ranges - how to visualize 0s?

That might be the solution. Give me a bit to check it out and I'll get back to you.

Super Contributor

## Re: Data table with missing date ranges - how to visualize 0s?

Am waiting for u my dear friend.

Regular Visitor

## Re: Data table with missing date ranges - how to visualize 0s?

Accepted your solution. It worked! Thanks pal.

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 6 members 3,394 guests
Recent signins: