cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
miba Member
Member

line chart issue - missing data

Hi Guys 

 

I am strugeling to find a solution for my line charts. I have a sales data (my fact table) which includes sales data and the order date granularity is week. There are a lots of accounts that only order 5 times a year as this is WHS. 

Then I have a date fact table which granularity is also on week ( it is not really data table becasue i can not use time functions as I dont have day granularity). I linked these two tables by week nr/year and created both direction relationship.

 

When I want to display data in line chart and put Week nr (without year) on the axis and sale in the value i am facing this issue:

 

line chart categorical xaxis.PNGline chart xaxis categorical typeline chart categorical xaxis 2.PNGline chart xaxis categorical type

 

Due the fact that some customers/accounts only place 5-10 orders per year they will have only few records and in the line chart the line will consist of points and short lines rather than one continuous line. 

When I change the X axis type from Categorical to Continuous I get a continuous line but then the weeks are only by 10th and the graph is confusing as you can see below. The points between week 4 and 53 are connected but the line shuld be at the zero as there was no sale.  

line chart continuase xaxis type.PNGline chart xaxis continuous type

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I just would like to make sure somehow that if there is no value for that week the becasue the customer didnt order it will be show zero in the graph. 

In the past I tried to create a calculated column that will "guarantee" always a value if there was no sale. 

I also understand that i should potentially look at higher granularity lets say month or quarter but I really hope that there is a way how to solve it. 

 

Thank you 

1 ACCEPTED SOLUTION

Accepted Solutions
jthomson New Contributor
New Contributor

Re: line chart issue - missing data

The workaround that's often used for this is to change whatever measure you currently use to calculate your sales by adding +0 to the end of it, I'd try that first

1 REPLY 1
jthomson New Contributor
New Contributor

Re: line chart issue - missing data

The workaround that's often used for this is to change whatever measure you currently use to calculate your sales by adding +0 to the end of it, I'd try that first

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 98 members 1,401 guests
Please welcome our newest community members: