In this blog post, I am going to create a R visual that renders the Gartner magic quadrant-like charts in Power BI using the ggplot2 package. A dummy dataset will be created, including three columns, the "Company" column holding the name of the companies which will be ranked in the quadrant chart, the "ExcutionScore" column … Continue reading R Visual – Create Gartner Magic Quadrant-Like Charts in Power BI using ggplot2 →

Update - I have suggested another approach here that allows users to dynamically specify the periods and the number of top items to evaluate, using the interactive dashboard slicers. When analysing the best performers against a specific measure such as the best sold products, we sometimes need to take multiple periods into consideration. For example, … Continue reading DAX – Find the Items Ranked in Top n for Multiple Periods →

I have been watching Eurovision competitions for several years. I personally think the voting results from Eurovision competitions can be a very good source for the research of relationships between European countries. In this blog post, I will create a social network R visual using iGraph package and use the visual to analyse the voting … Continue reading R Visual – Build Eurovision Voting Network Chart in Power BI →

The pbix file created for this blog post can be found in my GitHub here. Introduction Since Power BI started to support R visual, it has become difficult to criticise Power BI's visualisation capability because we can now take full advantage of R's powerful visualisation packages such as ggplot2 to create Power BI reports. Unlike … Continue reading R Visual – Building Facet Grid in Power BI →

Problem We can use the DAX RANKX function to return the rank of an item based on one of its numerical attribute. For example, we can create a measure using RANKX function to calculate the ranks of the product categories based on the order quantity within the product categories. This measure will normally work fine … Continue reading DAX – Ranking with Hierarchy Drill-Down →

When building a Power BI report page for analysing data by a specific dimension (e.g., customer, product and category), we often need to dynamically show the title of currently selected item(s). One trick to show the title based on the current filter context is to use Multi-Row Card visual (we can also use the single … Continue reading DAX – Dynamically Showing Title by Slicer in Power BI →

In one of my previous blog post, I described an approach to load text files from Azure Data Lake Store to Power BI filtered by the date period specified by users through setting the period start and period end parameters. That approach is capable to load text files located at the same folder. However, there … Continue reading Power Query – Parameterised Files Loading from a Year-Month-Day folder Hierarchy →

Problem It is not rare to see that multiple attributes are stored in a single text field especially for tagging enabled applications where an unfixed number of tags may associated with an article or post. Those tags are often stored in a single text filed with a delimiter to separate them. When reporting, we often … Continue reading Power Query – Extract Multiple Tags Stored in a Single Text Field →

Power BI now supports data load from Azure Data Lake Store. We can connect to a folder in the Azure Data Lake Store and load all files from that folder. However, we often don't want to or aren't able to load all the files in the Azure Data Lake Store folder into Power BI due to … Continue reading Power Query – Parameterised Files Loading from Azure Data Lake Store within a Given Date Range →