Show null values as "0" in line chart for last 4 weeks data
Hi, I need help in fixing the line chart. i want to indicate the values in last 4 weeks including if the value is zero as well. here is the issue brief. i have 3 tables. 1- FACT Table - tb_data 2- DATES Table - Tb_dimdate 3- Dummy Date Table - dummydates (which is copy of tb_date and is being used to get x-axis range for last 2 weeks based on Max(Tb_date) FACT Table and DATES Table are linked. i have created measure to calculate the data in last 4 weeks. here is the DAX expression. Last 4 weeks Data = VAR _maxdate = MAX(tb_DimDate[Date]) VAR _lastinperiod = DATESINPERIOD(DummyDates[Date],_maxdate,-28,day) RETURN CALCULATE( SUM(Tb_Data[Value]), REMOVEFILTERS(tb_DimDate[Date]), KEEPFILTERS(_lastinperiod), USERELATIONSHIP(tb_DimDate[Date],DummyDates[Date]) ) Tables have following relationship the line chart and matrix visual show only dates which have values > 0. i want to include even "0" values. i have tried both alternate solutions. 1- show items with no data (x-axis) 2- calculate( if(ISBLANK(sum() , 0 , sum() ) and both are not working. In both cases the x-axis range changes to complete dates table. Requirement: i need data for 4 weeks including 0 values in line chart.
