mhireholi
11 years agoNew Member
Status:
Under Review
DatesInPeriod () function accepts it's first parameter as "Date" only with default 12:00:00AM timestamp. What about for different time?
https://social.technet.microsoft.com/Forums/en-US/b6ccbaf4-cd8d-4bb7-993c-8d088b44adf8/disconnected-slicer-in-powerview-hour-day-week-month-year-max?forum=powerview#b6ccbaf4-cd8d-4bb7-993c-8d088b44adf8
5 Comments
- nishalitNew MemberThanks for the suggestion Manjunath. Who else would find this useful? Please add your vote if you think it is!
- manjunath_hirehNew Memberhttp://stackoverflow.com/questions/27498880/minute-hour-day-week-month-year-filter-for-power-view-charts-in-powe?answertab=active#tab-top looking for Minute Hour Day Week Month Year Max Filters in Power View charts.
- manjunath_hirehNew MemberThis is a very useful feature that allows users to drill down to Hour, Minute and seconds level to see what's happening with the data. Please add this at the earliest. Thanks.
- searyNew MemberI think it would be useful to me if you not only allowed datesInPeriod to accept timeStamp values but also allowed the interval parameter to support "hour" resolution. Right now, I think the best resolution available is "day". I have a situation where I am computing the the number of times something happened in the last few hours. camargos88 gave me some DAX that worked, but I think it's broke now and it's not entirely intuitive to read. Enhancing the DatesInPeriod function to work with hours might make the DAX more readable and easier to maintain: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Sum-of-Failures-Last-Hour/td-p/1037662 The above forum post is a fictional example of a real problem I am dealing with. It's actually far easier to compute the Sum of Failures (within the last few hours) using a language other than DAX, but DAX is what Power BI offers...
- fbcideas_migusrNew MemberStatus added:Under Review
Recent ideas
Allow Fabric Mirroring (change feed) on SQL Server 2025 databases with CDC enabled
Description: We had Fabric Mirroring working in production on SQL Server 2022, using the CDC-based method. After upgrading the instance to SQL Server 2025, mirroring stopped working, and it cannot b...Salmuera_99_1 hour agoFrequent VisitorNew7Views0likes0CommentsAdd a “Close all” option for open items in Microsoft Fabric
Description Microsoft Fabric currently allows a maximum of 20 items to be open at the same time. Once this limit is reached, attempting to open another item results in a message asking the user to c...vestergaardj2 hours agoMost Valuable ProfessionalNew4Views0likes0CommentsShow the Latest Semantic Model Refresh Time in Excel
Issue: Excel may show an older refresh timestamp for a Power BI semantic model even though the latest data is available due to 24hr SLA. Request: Update Excel to display the latest semantic model ...v-dugumarrir13 hours agoMicrosoft EmployeeNew9Views1like0CommentsNative GitHub-Style Version Control for Power BI Reports
It would be extremely valuable to have native GitHub-style version control in Power BI. A built-in feature to track changes, compare versions, view change history, create checkpoints, and roll back r...ChaymaeMB84 hours agoNew MemberNew2Views0likes0Comments