How to see what the actual values are in a FILTER when using a DAX Measure
I was working with a customer trying to get them to better understand DAX and one if the things that is difficult to understand is how the filtering works in DAX. The challenge I have found is that when using filters in a DAX measure I cannot visually see what is happening within the DAX Filter. Below I will show…
DAX – How to get a line break in a DAX measure for Labels or Titles in a Power BI report?
Once again, I really enjoy working with Power BI and in the data and analytics space. I was at a customer and they were drilling through between pages, and I wanted to put in what the filter selections were when they drilled through to the new page. This would allow them to easily see what had been on the previous…
DAX – Calculating the difference between 2 selections on a Slicer
Once again, I really enjoy answering questions on the Power BI Community, it keeps me challenged on how to find solutions to people’s requirements. This time the challenge was that a user on the forum was looking to calculate the difference between 2 selections made on a slicer. In this example the slicer was on a Product. Below is the…
When working with long measures in #PowerBI, it is easier to create them in the Data View
I have been working with a lot of DAX at the moment and the new DAX area is awesome. What I have found at times when working in the Report View, is that when I edit the DAX measures, I sometimes have to click on the arrow multiple times in order to get it to back up. This can be…
Do you know how to use Multiple Disconnected Slicers in Power BI?
I had previously blogged Power BI – Using a Slicer to show different measures where I showed the steps on to have a different measure based on a slicer selection. I got a few comments from that blog post, where people were asking if it was possible to have multiple Slicers which could be used. If you are reading this…
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…