Linked date hierarchy blank after scheduled refresh
Hi there I have a PBI report on our hosted PBI server. It is scheduled / updated nightly. I have a table (on left in image below) that has a Key and Last Updated fields. The Last Updated field has a relationship to a Date table that is created by a DAX (see code snip-it further below) and provides a hierarchy for Year/Month/Day. When you look at the table you can see the Year/Month/Day are blank. When I edit the PBI file in the Desktop app the table gets populated as I would expect (see image below). If I save the report all looks good on the PBI server but when the report is scheduled/updated the table reverts back. Any ideas why this is? Thanks for your time. Charlie Date = VAR BaseCalendar = CALENDAR(MIN('Autotime Query'[Week Worked]), MAX('Autotime Query'[Week Worked])) RETURN GENERATE ( BaseCalendar, VAR BaseDate = [Date] VAR YearDate = YEAR(BaseDate) VAR MonthNumber = MONTH (BaseDate) RETURN ROW ( "Day", DAY(BaseDate), "Year", YearDate, "Month Number", MonthNumber, "Month", FORMAT (BaseDate, "mmm") ) )
Power Bi averaging daily results to fixed budget
I am very new to Database work and Power BI. I have been tasked with creating a report that will calculate our daily hours for inservice ambulances and create a chart to compare it to our budgeted hours. I connected this very large database and built out a formula that looks at every shift start Date/Time and Stop Date/Time. I used the subtraction tool and then converted duration to a number. This all works. When I try to bring this into a chart and use the date Hierarchy to include year, quarter, month, day the averaging will not work. It bring it down to shift level. Is there a way to tally all the shifts in a day to compare it? Thank you for helping this Rookie. This is a small sampling of the data.
Report Server: X-axis title not changing dynamically when drilling down date hierarchy
In my line charts I'm using a Date Hierarchy in the X-axis. When drilling up from Month -> Q -> Year, the X axis title should be changing accordingly (M -> Q -> Y) but it keeps saying just "Month". I tested on normal PBI Service and it works fine. Please advise. You can see in the gif below. (in the gif, x axis is saying "Month" in Vietnamese. I changed the Date Hierarchy names to English for easier understanding but the Vietnamese title didn't adjust itself for some reason) https://gfycat.com/aggravatingthoseblackrussianterrier
