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…
BI-RoundUp – Power BI (User details in Usage Metric Reports, Power BI Report Server Aug Update – Timeline Story Teller Custom Visual)
Here is the weekly BI Roundup of what has been happening in the last week. Power BI – User details in Usage Metric Reports As you can see in the image above, the Power BI team has now incorporated the capability to see which users have been accessing the reports. This is really awesome because it not only allows you…
BI-RoundUp – Power BI (On-Premise Gateway Update August – What If Competition – Solution template for Microsoft Dynamics 365)
Here is this week’s BI Round up with the latest weekly information. Power BI – On-Premise Gateway update for August As you can see above in the August update there is now support for IBM Netezza connector the new TLS format 1.1 and 1.2. It is also good to see that they have increased the timeout for gateway requests from…
Power BI – Using Change tables to compare data
Have you ever wanted to compare changes in your data without having to create duplicate copies, as well as make it really simple and easy for users to do some self-service comparisons? In this example I am going to show how I created and then used Change tables to compare data where you can select multiple items to compare. This…
BI-RoundUp – Power BI (August Desktop Release – Timeline Story Custom Visual – Help Shape the Future of Power BI – Text Analysis Solution Template using Bing – Azure Activity Log Solution Template – Survey for Mobile Apps – Developer Update for August)
While the week before had nothing to really talk about that is new, this week there is a whole host of updates and great new things to play with so here are the latest details. Power BI – Power BI August Desktop Release Whilst this picture above may not look like much it is incredible with this new “What If”…
Power BI – Using Functions for repeatability and can easily repeat Applied Steps to your data
In the past I did create a blog post where I demonstrated how to get the location of a user based on an IP Address What I did forget to elaborate on and what really makes Power BI even more powerful is how easy it is to create and use a function. So this is the goal of my blog…
Power BI – How Disconnected Slicers can enrich & transform your analytics data
I have been using disconnected slicers for quite some time. What I love about them is that you can use them so that a user does not have to go to individual pages to view different measures or values, but can easily click on the disconnected slicer, which will then change the measure or values for them. I find this…