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…
BI-NSIGHT – Power BI (November Desktop Update, Mobile App Update)
I now expect if not on the last day of each month, but pretty close to the last day is to get the updates for the Power BI Desktop and potentially the Mobile Apps update. And this month I am not disappointed. Power BI – November Desktop Update Once again the Power BI Team has been very busy with a…
Power BI – Quick Tip – Overcoming additional columns in CSV or Flat Files
This quick tip explains how to overcome an issue with using CSV or Flat Files and you get additional columns. I have been working with CSV Files, and what often happens is that you get years added into the columns on a CSV File as shown below is what the original file looks like. And this is what the source…
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 – Using Parameters for Flat File / CSV / Excel Sources
I was recently catching up on Blogs as I always find this a wealth of information and it often leads to me learning something new. Which I can then leverage in my current work environment and this is one of those cases. This is to show how using Power BI and the built-in Parameters it can be capable of handling…