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 Experts,
I need help from you as I want supervisor wise team count and date wise working employee count.
I have 2 tables , one for team and other for working. Sample data can be downlaod from below link -
https://drive.google.com/open?id=154oqbFXjJ3J5DknGrmC9kk7AYVTe6M4G
Kindly help me asap
Solved! Go to Solution.
Hi @Anonymous,
Please take a look at on below link about ideas forum:
Power BI Ideas - How can we improve Power BI?
You can type the keywords of your requirement in the textbox, then it will try to search for similar ideas or display the advanced panel to let you submit a new idea:
Regards,
Xiaoxin Sheng
Hi @Anonymous,
You can link the team table and working table based on employee id, then you can create a matrix visual with 'Supervisor Name' as row, 'Activity_Insert_At' as column(hierarchy mode year month day fields), aggregated 'Activity_Id' with count mode on value filed. Then your records will be summarized automatically.
Regards,
Xiaoxin Sheng
Thanks @v-shex-msft for the same.
1 -Is there way to put Total in starting rather than showing in the end. ?
2- Can I show May 1, May 2, .......... in place of 1,2,3..... as a date ?
PLease help.
HI @Anonymous,
I check the matrix settings but not found any options that allow you to change the location of the total level.
Maybe you can submit an idea for this requirement to add support to 'pin' fields to change the location of the total level.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Please take a look at on below link about ideas forum:
Power BI Ideas - How can we improve Power BI?
You can type the keywords of your requirement in the textbox, then it will try to search for similar ideas or display the advanced panel to let you submit a new idea:
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Please share some sample data with the expected result to help us clarify your requirement, it is hard to coding formula from your description.
How to Get Your Question Answered Quickly
BTW, your sample seems contained a few date fields in column. Maybe you cna try to do unpivot columns to convert them to attribute and value list, it will help to calculate across multiple date ranges.
Unpivot columns (Power Query)
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
You can download sample data and Result data in the excel that you can download from below link
https://drive.google.com/open?id=154oqbFXjJ3J5DknGrmC9kk7AYVTe6M4G
Dear @GilbertQ
There is one sheet "Result" in that you can see desired output.
Kindly let me know if you need any other information my end.
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.