Need to show the date in graphs if not available data in particular dates also

[Samba777ravuri]

Hi Team,

We need to show the data of last one week for below graph based on the date of user selection.

And also if the date is not aviabale particluar day also need to show in graphs as blank.

Measure we are using:

Avg_Rinse_Temp_7_Days =

VAR selected_date =

SELECTEDVALUE ( dimDate[DayDate] )

Return CALCULATE (

DIVIDE(SUM(factWareWashEvents[RinseTempSum]),SUM(factWareWashEvents[RackCount])),

CROSSFILTER ( dimDate[DateKey], factWareWashEvents[DateKey], NONE ),

FILTER (

Date_Table,

Date_Table[DayDate] > selected_date - 7

&& Date_Table[DayDate] <= selected_date

)

)

Existing o/p:

Expected o/p: i want to show date of Jan 31st and 1st Feb and 2nd feb also in that grpah.(blank also fine for these dates).

Kindly anyone suggest this scenario?

[Anonymous]

Hello @Samba777ravuri 
You can try this.

Avg_Rinse_Temp_7_Days =
VAR selected_date =
SELECTEDVALUE ( dimDate[DayDate] )
VAR _Avg = 
CALCULATE (
DIVIDE (
SUM ( factWareWashEvents[RinseTempSum] ),
SUM ( factWareWashEvents[RackCount] )
),
CROSSFILTER ( dimDate[DateKey], factWareWashEvents[DateKey], NONE ),
FILTER (
Date_Table,
Date_Table[DayDate] >= selected_date - 7
&& Date_Table[DayDate] <= selected_date
)
)
RETURN
IF( ISBLANK( _Avg ), 0, _Avg )

[Samba777ravuri]

yes, tried your logic...Same issue exists.

Expected o/p :

[Anonymous]

Hello @Samba777ravuri 
Can you please share your pbix file after removing the sensitive data?

[Samba777ravuri]

Thanks for your Response, I have 100 MB file, lt me share some dummy file...please share your email here