Power BI Relationship Modelling – Star Schema In our blog post called: Relationship Modelling – Part 1 we spoke about relationships in Power BI and what it entails. We also spoke about the importance thereof to really understand how to create relationships. This blog post will look at relationship modelling, the means of building your
Data Preparation Part 6 – Star Schema Power BI Read More »
Power BI Merging and Appending Queries Let’s start off by explaining what merging and appending queries in Power BI entails and the difference between the two. In short, when you have one or more columns that you’d like to add to another query, you merge the queries. When you have additional rows of data that you’d like
Data Preparation Part 3 – Merging and Appending Queries Read More »
Power BI Relationships In Power BI we will most of the time work with data models that contain data from multiple tables that must be connected through relationships. Well prepared and thought through tables that are connected by relationships are required between these tables to function together to allow visualizations to be sliced and diced
Data Relationships in Power BI Read More »
Power BI Desktop Update – May 2019 Power BI has really ensured that they keep improving the product and it is brilliant as there are constantly new improvements being deployed based on user feedback. This allows for very satisfying user experience as you know some of the most pressing issues will be dealt with a
Power BI Desktop Update – May 2019 Read More »
DAX TOPN This blog post will outline the Power BI DAX TOPN function. The DAX TOPN function is a very practical useful function as we often want to see the top performing products by sales, region or shop. TOPN syntax TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…]) Parameters n_value The first parameter will determine the number
Power BI DAX TOPN function Read More »
DAX Time Intelligence Functions In this blog post, we are going to look at three DAX time intelligent functions. These DAX time intelligent functions are PARALLELPERIOD, DATEADD and SAMEPERIODLASTYEAR. I know many of you will say the functions sound very similar and that they have more or less the same functionality. This is not the
Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD Read More »
Total Value in a Stacked Column Chart I have recently run into the frustration that I cannot display a data label for the Total Value for a stacked column chart in Power BI. Data labels are only displayed for each category of my stacked chart, however, no data label is displayed for the Total Value
Power BI: Displaying Totals in a Stacked Column Chart Read More »
Pivot and Unpivot walkthrough in Power BI Power Query in Power BI provides very effective functionality to pivot and unpivot columns. For the pivot functionality you turn rows to columns and for the unpivot functionality the inverse is true where columns are transformed into rows. Power BI Pivot We will be working with the following
Power BI: Pivot and Unpivot Columns Read More »
March Update of Power BI Desktop March sees another exciting release for Power BI Desktop update. There are great additions to reporting in Power BI, especially with the addition of the Report page tooltips (preview). Analytics sees some improvements to Q&A with the ‘did you mean’ functionality as well as some formatting updates for maps.
Power BI Desktop Summary Update – March 2019 Read More »
Power BI Desktop Update – Feb 2019 Power BI has released their first update for 2019 for Power BI Desktop. This update is filled with some exciting features that enhance what you are capable of achieving through Power BI. Two of the most exciting updates is in the analytical section where the Key Influencers visual
Power BI Desktop Summary Update – February 2019 Read More »
