Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Would like to ask for your help in getting and show the "Weekly Average" per assigned manual and assigned fieldman in the line graph:
For my date range in the X axis, im using this formula':
@icdns , Not very clear. Can you share sample data and sample output in table format?
See if this can help
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
Hello,
For example, i have data, I have a matrix table where in it displays the total fieldman assigned in Manual and fieldman for that week range.
So in my line graph, I wanted to show the average fieldman per assigned manual and assigned fieldman in my line graph per WEEK RANGE.
This is my line graph:
X axis shows my week range and Y axis shows the percentage.
The points are the average.
Thank you.
HI @icdns,
Please share some dummy data that similar to your raw table structure to help us clarify your data structure and test coding formula on your sample data. It is hard to direct coding formula on visualization records.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |