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
Enable mirroring of Google BigQuery Views
currently only tables are supported, Please enable mirroring of Google BigQuery Viewsjayantjape47 minutes agoRegular VisitorNew63Views1like1CommentRestore PNG snapshot attachments in Power BI report subscriptions
Microsoft recently migrated Power BI report subscriptions to a new email delivery platform. As part of this change, report snapshots are no longer delivered as separate PNG attachments and are only e...modch3 hours agoNew MemberNew87Views10likes2Comments