Slope Graph with Core Visuals - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
How I created a slope graph with Power BI Core Visuals. Many people have demonstrated how to create a slope graph with Power BI Core visuals, but I was curious how this would look with the most recent (September 2021) Power BI Updates. Most Slope graphs I had seen in Power BI did not have… Continue reading Slope Graph with Core Visuals
Colorffy - Find or create harmonious color combinations.
Colorffy makes it easy to create gradients, palettes, or random colors. You can save them for later, or you can use the save & copy features to use your color schemes in other apps.
As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, there …
Microsoft Hates Greg's Quick Measures - Microsoft Power BI Community
Microsoft Hates Greg's Quick Measures Image concept and credit: Rocket Deckler Introduction Today I am announcing the availability of a new External Tool for Power BI Desktop, "Microsoft Hates Greg's Quick Measures" or MSHGQM for short. This tool more than doubles the number of Quick Measures avail...
Power BI Centre of Excellence, What and Why – Part 1 of PBI COE Series.
Power BI CoE is an important concept if it is understood that Power BI implementation does not end when the platform is open and available to your organisation. Implementation starts at this point.…
Building the Business Case for a Power BI Centre of Excellence – Part 2 of PBI COE Series.
To realise the vision of a CoE, a common and fundamental requirement is to have support from your organisation’s leadership. CoE is no different from any other investment within a company: you will…
Scoping a Power BI Centre of Excellence – Part 3 of PBI CoE Series.
Organisations come in many shapes and forms, so do their needs. Scoping a Power BI Centre of excellence is time sensitive, as nowadays, companies are in constant evolution. The BI journey has many …
Resourcing and Structuring a Power BI Centre of Excellence – Part 4 of PBI CoE Series. – Smart Power BI
scope for the CoE, and in addition, you might have some existing team members and you might need to recruit as well. This article covers not only the skills, knowledge, and behaviour of your CoE, b…
Replicating SQL windowing functions in Power Query. | Purple Frog Systems
I’m sure you’ve all heard of windowing functions in SQL Server? But what if you need to replicate these windowing functions in Power Query? Here I have a sample CarSales.csv dataset of car sales per brand, per year, per month and the number of units sold. I will use this dataset to demonstrate how we […]
Checking Boolean conditions while creating a like for like comparison in DAX - SQLBI
In DAX, optimizations and data types do not always play nice and can leave you dealing with surprises. In this short article, we see an example of how mixin