It seems a recent update to the Power BI Service has a bug in it. We can no longer expand the Data Fields or Visualization pane when editing a report in the PBI Service. We have tried in Chrome and Edge with the same results. Please fix soon!
I just received an email from Microsoft that the ETA for a fix is August 5th.
Having the same issue. Tried the above fix but that doesn't seem to work either. Any other ideas? This is crazy unworkable...
The ETA for the bug fix is August 5th.
I ran across a post in the Service section questioning why Microsoft would restrict the length of the Field Names. I can confirm that I am also experiencing the issue. Generally, when editing a report or building a report, you could extend the list of field/measure names to choose the appropriate one for use in the visual. The double headed arrow still appears but when I click and drag, nothing happens.
Has anyone else noticed this issue?Using Chrome.
I'm fairly new to PBI. Please help me with greater detail.
In my organisation, we need to measure people's (across Australia) contribution. In order to do that we are capturing all task that they are completing on a daily basis. Each different task has allocated different time to it. In order to obtain their contribution, "Total time to complete all task" would be our Numerator.
In order to calculate contribution, we are require to know their capacity as well. A full time employee is working 7.5 hours a day. However we need to exclude all leaves (annual leave, sick leave), all public holidays and weekends. Capacity would be our Denominator.
Currently we have calculated a flat % of all leaves and weekend portion and bring employee's working commitment down from 100% to say 60%! This 60% is then applied to their full capacity (7.5 hours) which brings their full time capacity for a day down to 4.5 hours for a day!
Current process Example:
(A) Measure to calculate capacity =
Above percentage calculation is based on a full year. However the issue is when management is looking at a quarter or even a month data how their staff is performing is not giving them an accurate picture as if we take a month example, there is not all public holiday falls within that month or not all leaves have been taken into that month and not all weekends (52) falls into that one month! So looking at month or even quarter level view is not an ideal with this calculation as it's not flexible enough! I have a date table with column called "IsWorkDay" (value 0 or 1), to pick if a given date is a weekday or weekend? I can incorporate public holiday in the same way but people sometime works on the weekends (obviously they are not oblige to do so) and completed their task during weekend, this will not capture as part of their total effort as the system date stamp whenever they complete the task!
I would like to consider all leaves, holidays and weekends to calculate their capacity but would like to include all works that has completed even they are not at work!
Sorry for long post but I though providing more detail would give greater understanding of the issue which leads to a quick solution!
Looking forward to getting help on this.
You will need to move this into a forum for assistance on this particular problem.
Until then then, I would suggest looking at your fact table and completing a distinct count of days there instead of doing all of the calculations for dates in the date dimension table. If an employee worked, there should be daily data in the fact table that can be used in place of a calculation based upon a calendar table.
Has this been resolved for other users? I'm still experiencing this and it's incredibly frustrating. Building reports in Power BI Service is taking me so much longer because I can't widen the Field Pane. What's the ETA?Thanks