DAX (Power BI) – Dynamic TopN made easy with What If Parameter
In this post I am going to demonstrate how to create a Dynamic TopN slicer using a What-If Parameter. This will allow your user to simply use the Slicer/Slider to view the TopN values and as a bonus if the user slides it to zero, it will display everything! Who doesn’t like something that is easy to create, but makes…
Power BI – How to do Pagination in Power BI Reports
In this blog post I am going to demonstrate how to achieve Pagination in Power BI reports, using the new Bookmarking feature. I got this question from a follower on Twitter Murali Krishna With the new bookmarking feature there now is a way to make it appear that you can page through Power BI reports. Below is what it looks like in…
Power BI – Using Reports Usage Metrics to create Custom Reports & Leverage them for other App Workspaces
In this blog post below I am going to show you how I created my own Custom Usage Metrics Report. NOTE: This has been done using my Report Metrics and not the Dashboard Metrics. NOTE II: I am going to refer to the Reports Usage Metrics as RUM (It has a nice ring to it) And then how I changed…
BI-RoundUp – Power BI (Desktop Update for June, Service Updates for June, Dashboard Email Subscriptions) – Excel (Get & Transform Updates June 2017)
Here is my weekly BI-RoundUp with what has happened and what is new. Power BI – Desktop for June Finally the Power BI Desktop July update is here. So here are the details below of the new updates. Reporting The table and matrix visuals are now generally available. Not only that but they have also made some additional enhancements which…
Data Insights Summit Details – Day 1 Summary
With the Microsoft Data Insights Summit that is currently happening in Seattle the Power BI team has been really busy letting us know what features are coming and what to get excited about in the coming months, so below is a quick overview of what has been released after Day 1.
BI-RoundUp – Power BI (Office 365 Adoption Content Pack – Embedded Accelerator) – Excel (Get & Transform Updates May 2017)
This will no doubt be a quieter week, leading up towards the end of May and into June when there will be the next wave of updates from the Microsoft Power BI Team You might also notice that I have changed the name from BI-NSIGHT to BI-Roundup, as there was another blogger who has his blog URL as BiInsights, so…
Power BI – Free vs Pro Infographic
I have been active on the Power BI Community Page for quite some time, and what I have often seen is people not quite sure what options are free and what options require a Pro license. So here is my infographic in which I have put down which options are free and which options will require a Pro license. I…
Power Query – Adding Parameters within a piece of text
Below is where I had a situation where I wanted to put in a parameter within a piece of text. This was so that I could then dynamically change the Month Version for my budget and when I refreshed my data it would then use my specific Month Version. This was due to the requirement being that they wanted the ability to…
BI-NSIGHT – Power BI (Microsoft Flow & Power BI, Webinar How Microsoft Handles Power BI)
I have no doubt that as the year moves closer to the end of the year there will be slightly less news and updates. But with that being said here are this weeks updates. Power BI – Microsoft Flow and Power BI I have been personally looking at Microsoft Flow lately and it can really automate many tasks, as well…
Power BI Quick Tip – Using Parameters in Power Query Filters
I have been working lately quite a bit in Power Query and having to shape and re-create data based on the requirements. They had a requirement to make the data dynamic and immediately the Parameters in Power BI came to mind to create the solution. Now as we know using Parameters in Power BI has a lot of advantages. But one quick…