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 Guys,
Could you suggest an idea to plot the graph like this in a dynamic manner in the date filed? it needs to adjust automatically based on the current day
2) auto toggling between graphs on every 10 minutes one graph to another graph in clockwise. Please suggest
eg: same day last week
Solved! Go to Solution.
Hi @nagoor,
You can try to use following formula to get 'same day last week' average of available amount:
Measure = CALCULATE ( AVERAGE ( 'raw data'[Availability] ), DATEADD ( 'raw data'[Period], -7, DAY ), VALUES ( 'raw data'[Hrs] ) )
Regards,
Xiaoxin Sheng
Hi @nagoor,
#1, Yes, it is possible to create a 'same day last week' graph line in line chart, can you please share some sample data for test and coding formula?
#2, Nope, I don't think it is possible to achieve this requirement.
Regards,
Xiaoxin Sheng
hi @v-shex-msft
Thanks for your response, i have attached the sample data. please have a look and provide your comments.
Thanks,
nagoor
Hi @nagoor,
You can try to use following formula to get 'same day last week' average of available amount:
Measure = CALCULATE ( AVERAGE ( 'raw data'[Availability] ), DATEADD ( 'raw data'[Period], -7, DAY ), VALUES ( 'raw data'[Hrs] ) )
Regards,
Xiaoxin Sheng
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |