Using Power BI to ensure Daylight Savings Dates and Times change dynamically
I was helping on the Power BI Community and it struck me that there currently was not a way to easily manage Dates and times for Daylight savings. In this blog post below, I will show how I achieved this by using parameters and little bit of M magic (Directly Editing the M Code). As part of completing this solution I…
Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & Times
I was working for a customer recently, where the requirement was to create a slicer which would only show the data for Today, Yesterday and then all other days. When I was consulting with the other developers they were unaware that the Power BI Services Servers all have the Time zone set to UTC. And this applies to ALL Power…
BI-RoundUp – Power BI (Enterprise Capabilities for Power BI – Premium Click Through Demo – Campaign/Brand Management for Facebook – Power BI Report Server Roadmap – Understanding Power BI SKUs) – SQL Server 2017
With Microsoft Ignite happening this week there have been a whole host of announcements to Power BI which is great to see. So please read below for all the additional updates and details.
Power BI – Using OneDrive to Embed and Host Images for Power BI
I was recently on the Power BI Forums and I have seen a question before around where and how to host images that can be used within Power BI. I am going to show this with the example below. I am going to show you how to upload images to OneDrive, which can host your images for free. Then I will…
BI-RoundUp – Power BI (On-Premise Sept Update – Developer update for Sept – Congrats to What-If Winners – Custom Connectors in Action – Timeline Storyteller custom visual contest)
There have been quite a few updates in the past week, so please find all the related updates below, of which there have been quite a few! Power BI – On-Premise Sept Update In this month’s update for the On-Premise Gateway they have added support in the Personal mode for national clouds. There has also been a great improvement in…
Power BI – Creating Dashboard or Report Email Subscriptions
I have seen a few questions asked in the Power BI Community Forum with regards to why people are not receiving their Email Subscriptions (Dashboard or Report). So I thought it would be best to create a quick blog post to hopefully help a few people. So below I will show how to create the subscription as well as some…
BI-RoundUp – Power BI (Desktop update for September – Service update for August – Filters coming to iOS App – How Feedback influences Microsoft Business Applications Development)
This is the weekly update in the world of BI Power BI – Desktop update for September We now have got the September release of Power BI Desktop and there have been almost all of the updates in the reporting area within Power BI Desktop, so as I do with every monthly update I will give an overview below. Reporting…
Power BI – Creating Text based on TOPN values from Filters ordered by measure value
When I was working on the What-If contest, one of the requirements that I wanted to add was text based details. But the kicker was that when I put the text values into a measure it was showing the values, but based on an alphabetical order instead of being based on the numerical values. One challenge for me was to…
BI-RoundUp – Power BI (Drill Through coming… – Timeline Storyteller Competition)
TimeTimeTHere is the weekly BI Roundup Power BI – Drill Through coming – Already in the Power BI Service As you can see above the Power BI Team has already enabled the Drill Through functionality into the Power BI Service. This is something that was seen at the Microsoft Data Insights Summit and it is here. I think that this…
DAX – Filtering Measure to show value when selected or no values selected
I had a requirement where I had a measure that I wanted to be filtered if it’s value was selected then it must show the value. As well as if nothing is selected on the slicer then I also want the value to be displayed. I did this so that when the users are using the report, it will clearly…