How do you quickly change Text Size or other Visual Properties all at once in a Power BI report?
I was working on a larger Power BI report and there were quite a lot of tables, where the text size needed to be changed. Using the new search box feature in the Formatting options I searched for Text. This then gave me all the options where I had a text value as shown below. Yes, there are more text…
Are my DirectQuery Tables still in DirectQuery Mode, how to ensure they stay that way?
I have been doing some work with Power BI Composite models, and what I have found is that often the DirectQuery table can be changed to an Imported table. I personally feel that this blog post will be an important reference for me and hopefully others when you start to use Power BI Composite Models, to ensure that the DirectQuery…
The Complete Power BI Infographic – Update for Dec 2018
I recently had a look at my last version of my Infographic and I realized that I had not updated it for a few months and there has been a lot of incredible additions to the Power BI ecosystem. My infographic not only contains the details outlined below, but all the prior updates too. It is incredible to see how…
DAX Measure – Getting Difference between 2 values in a table
I had a requirement where the customer wanted the difference between 2 values in a table. The challenge here was that because the values are already part of the table, I had to find a way to get the unique value for each item. This would then allow me to calculate each value separately and then calculate the difference. This…
Power BI InfoGraphic Update – Sep 2018
It has been a few months since I have updated my Power BI InfoGraphic and with the speed at which this all changes and updates I have always had a challenge to keep it up to date. The following items have been added with links to more details: Composite Models Buttons Aggregations Comments in Dashboards New App Workspaces Geographic Distribution…
BI-RoundUp – Power BI (Service & Mobile Update for July & August 2018 – User Research Panel – On-Premise Gateway Update for Sep – Webinar on Power BI Dashboard Comments)
Here is this weekly BI-RoundUp where I will detail what updates there have been in the past week. Power BI – Service & Mobile Update for July & August 2018 In the past two months there has been a lot of updates to the Power BI Service and the Power BI Mobile App. All the details are below with links…
DAX – Getting the Start Date of the following Week
I was recently doing some work for a customer where they wanted to compare their date to the start date of the following week. They also had a requirement to persist the data to the dataset. I thought that this would be a good challenge to use DAX with a calculated column. I most certainly could do this using the…
BI-RoundUp – Power BI (Sep Update for Power BI Desktop – Dashboard Comments – Community Contribution to PowerShell Cmdlets – Power BI PowerShell Cmdlets available in Azure Cloud Shell)
Welcome to another week of my Power BI Round Up. And as expected there is another massive Power BI Desktop Update. Power BI – September Update for Power BI Desktop As always I am going to over the new features and highlight what I think is really relevant in terms of what has been released. Reporting With the added support…
What runs under the cover when I open Power BI Desktop
I am always interested in what happens under the covers when I open Power BI Desktop. So I did a little digging and I got the inspiration from Macro Russo when he did his Webinar as well as presented at the Queensland Power BI User Group on “My Power BI report is slow: what should I do?” What happens when…
BI-RoundUp – Power BI (Report Server Update – Aug 2018 – Ask a Question Generally Available – URL Filter Improvements – Python Episode 1 – Multi-Geo Support for Power BI Embedded)
Here is the weekly roundup, and as always the Power BI team has been very busy over their summer releasing some incredible features. Power BI – Report Server Update Aug 2018 I am not going to go through all of the updates to the Power BI Report Server, due to almost all of the functionality already being released in Power…