Forum Discussion
Avoiding SUM blanks creates date problem on chart
Super UserTo me, the behavior seems fine. When you have blank values at the start, the chart is ignoring the blanks or you will not get data for those months to you only see non-blank datadata.
When you add +0, you get data for the blank row. This also a kind workaround to get outer join. So now you get 0 row data, which can be shown in the chart/visual so in displays
What is objective of adding 0
The objective for adding +0 is avoiding blank in my matrix. When the costs are blank, in my opinion it should show as 0.
I don't understand why my chart shows more dates than set in the page level filter. In my page filter I request for the last 30 days, which breaks when adding +0 to my Cost SUM calculation.
Hi Anonymous ,
Could you please provide some sample data in table "fact Costs" and the fields or measures be applied on below chart in order to make troubleshooting? Thank you.
In addition, please try to update the formula of measure"Costs" as below with function COALESCE, then check if that chart still display more dates than you want...
Costs = COALESCE(SUM( 'fact Costs'[PreTaxCost]),0)Best Regards
Rena
Here is an example of a part of the costs Fact table. As you can see there are some null values for certain dates, which I want to display as €0 instead of BLANK on my matrix and Chart.
I tried the COALESCE approach, but it still created the side-effect that my chart ignores the date filter after adding COALESCE.
Hi Anonymous ，
Now that these blanks be set to 0, they should be displayed on the visual, so maybe we can add a visual-level filter to filter out these records with a value of 0.
Best Regards
Rena