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! 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?
Solved! Go to Solution.
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
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
Thanks man, but it's already set to 'continuous'
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
That might be the solution. Give me a bit to check it out and I'll get back to you.
Am waiting for u my dear friend.
Accepted your solution. It worked! Thanks pal.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |