Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |