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 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:
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?
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 :
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
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 |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |