Power BI – How to Filter Slicers dynamically
I had a requirement where I had a related table (or dimension table) in which was used as a slicer. But when it was changed to a slicer it was showing all the values in the related table, even if there was no data. So below I show and explain how to overcome this and show how to filter a slicer…
BI-NSIGHT – Power BI (Email Subscriptions, New APIs for Custom Visuals, Accounts Receivable Solution Template for SAP, Help Improve Direct Query) – SQLBI (Vertipaq Analyzer 1.7) – SQL Server (Power BI Reports in Technical Preview, Getting Started with Technical Preview of Power BI Reports)
It appears that we are now getting back into the swing of things, and this means more updates and additions to the Business Intelligence World. Power BI – Email Subscriptions This was a feature that I know I have personally been waiting for as well as a lot of other people. And yes this is very basic at the moment…
Power BI – Error – Sorry, we couldn’t find that report (When opening a link from an annotated email from the Power BI Mobile App)
Today where I am contracting there was an issue when a director annotated and shared a report item from the Power BI Mobile App with a colleague (Lets call him Bob) When Bob received the email to the report, he got the following error when trying to open the link, as shown below. The interesting thing was that when I…
BI-NSIGHT – Power BI (January Desktop Release, Featured Data Stories, Mobile Phone Reports Generally Available, Embed Power BI report into Salesforce, Auditing & Assign Pro Licenses with PowerShell
I cannot believe that 2017 is already where and straight out of the blocks we have already got some new features and changes to play with. So let’s get into it and I have a feeling that this is the year that Power BI is going to dominate and become one of the leaders in the Self Service Data Analytics…
Power BI – Quick Tips (Removing Black Line when Printing, Printing to show all graphics and Finding Custom Colours)
In this week’s blog post I am going to cover some quick tips around printing and colours. I have found that when working with real customers these are the types of questions which get asked frequently. Removing Black Line when Printing As you can see below, you get this black line showing when you select the Print option from your Power…
Distribute Power BI Pro features to Power BI Free Users – UPDATED NO LONGER VALID – 25 Jan 2017
Please note that since I created the blog post, Microsoft have resolved the details below, and indicated that it was a known bug within Power BI. So the content below is now no longer valid – 25 Jan 2017 What would you say that as it currently stands (Jan 2017) there is a way to distribute your Power BI Dashboards…
BI-NSIGHT – Power BI (SSRS mid 2017, Mobile Apps Update, OkViz Custom Visuals Updates) – SQL Server vNext (Get Data Experience,
Whilst last week there was not a lot of news in BI, Microsoft has been releasing some information which does make it feel like Christmas in the area of BI! Power BI – SSRS Mid 2017 This was really some welcome news especially for the people who use SQL Server Reporting Services (SSRS) and are looking to use the Power…
Power BI (DAX) – Quick Tip – How to count how many items are selected on a Slicer
Update: 16 December 2016 (I got a comment from Marco Russo, who suggested that can use the FILTERS DAX Syntax which will “Return a table of the filter values applied directly to the specified column.” As well as this should also be faster. I am all about the speed! I was working on a Power BI Project and one of…
BI-NSIGHT – Power BI (Mobile App Update – Android Tablets, Navigation Preview, AMA, Driving Power BI Adoption in your Organisation) – Excel (Get & Transform Update)
It does appear that as we approach the festive season, the Microsoft team are still full steam ahead, which is great for myself and the Data Analytics community. Power BI – Mobile App update for Android Tablets As per their blog post, it is great to see that there now is an App for the Android tablets, whilst this has…
Power BI – Using Parameters in Calculated Measures (Making Calculated Measures Dynamic based on Parameter)
What this is going to explain below is how I use a parameter that a user has entered to make a Dynamic Calculated Measure based on the Parameter entered. Example Scenario In my model I have got Parameters for the Fiscal Start Year So I want to create a calculated Measure that will get me the values for 4th Year…