DAX – Concatenating Values only when values are selected
What I am doing with the DAX below is to only show the concatenation of values if a value is filtered. If nothing is filtered (Selected) then display text to show that nothing has been selected, otherwise display in a concatenation what has been selected. NOTE: If you individually have to select each item, it is still being filtered so…
Reactivated Players DAX Pattern
I had a requirement where my customer was looking to gain some insights into their data relating to reactivated players. The definition used for a reactivated player is a player that has previously played but has not played for a certain number of days. The player then comes back and plays again. So, by this definition the player is reactivated….
Resetting Page back to Defaults using the New Buttons Feature and Bookmarks in Power BI
In this blog post I am going to show how to use the new Buttons feature to reset your page back to all the defaults, using the new Buttons and Bookmarks I have started implementing this on report pages and find it very handy for end users to just reset the page and not have to concern themselves with de-selecting…
BI-RoundUp – Power BI (Drill up, Drill Down Mobile App – USA Facts on Financial Data)
Here is the weekly BI-RoundUp, not too much going on this week, which gives me a little time to breathe! Power BI – Drill Up, Drill Down on Mobile App The Power BI Mobile App has been updated to so that now it is a lot easier to drill up or drill down on the visuals on the mobile platform….
Azure Analysis Services or SSAS Tabular 2017 – How to put in Custom TSQL Server Queries using the SQL Server Window
I have recently been working on SSAS Tabular 2017 for the current customer I am consulting at. Along with this I am starting to see that Power BI Premium features are appearing to lean more towards SSAS, so I personally feel that getting into SSAS Tabular 2017 is a great way to understand and work with a similar version of…
How I keep ontop of Power BI Support Issues
When working with Power BI on a daily basis, as well as chatting to various customers or users, one thing that I have missed in the past was to be aware of any Power BI Support Issues that are happening. So what I did was to build a Power BI Support Issues page, which I refresh daily, and then using…
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev, Test & Prod)
As I am sure a lot of people noticed if you now go into the settings of your dataset there is an additional option which says Parameters. What I wanted to test out was to see if I could change the connection strings using the Parameters in the Power BI Service. The advantages of this working in my opinion is…
Why are my Power BI Persistent Filters Not Working – Quick Tip
I was recently testing out the new Persistent Filters in Power BI and initially it would work with some reports and not with other reports. I even looked at imported data models, vs DirectQuery/Live Connection reports and I could figure it out. So, I reached out to the very helpful people in the Power BI team, and they quickly showed…
BI RoundUp – Power BI (March Desktop Update, Share Content with anyone via email, Persistent Filters, Mixed Reality App, Service & Mobile Summary for Feb, Data & BI Summit)
After getting back from the MVP Summit in Bellevue, which was an incredible experience the Power BI team has been extremely busy getting some great new features out the door. Which means there is quite a lot to cover in this week’s BI-RoundUp. Power BI – March Desktop Update Once again, I must repeat what I have said before, the…
Walk through on sharing Power BI Content with Outlook.com (Hotmail, Live), Gmail.com by email
The sharing Power BI Content expanded further on 08 Mar 2018, where by you can now share content with email addresses such as Outlook.com or Gmail.com In this blog post I will walk through how this is done. I will demonstrate what it looks like for the user who receives the email, and ensure that they can log in and…