cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samba777ravuri
Frequent Visitor

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

 

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:

 

 

 

Samba777ravuri_0-1612332294779.png

 

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?

4 REPLIES 4
TarunSharma
Resolver III
Resolver III

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 )

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

Expected o/p :

 

Samba777ravuri_0-1612333903568.png

 

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

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors