cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ytc-reports Regular Visitor
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:

data-table.png

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:

 

graph.png

 

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
Baskar Super Contributor
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
Baskar Super Contributor
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 

1.JPG

 

 

 

 

ytc-reports Regular Visitor
Regular Visitor

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

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

Baskar Super Contributor
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 

 

ytc-reports Regular Visitor
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.

Baskar Super Contributor
Super Contributor

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

Am waiting for u my dear friend.

ytc-reports Regular Visitor
Regular Visitor

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

Accepted your solution. It worked! Thanks pal.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 6 members 3,394 guests
Please welcome our newest community members: