How to navigate Power BI tables and bar charts

Are you new to using Power BI? Here's a few tips on how to navigate bar charts and tables. To explore a Power BI report, it's all about clicking on diagrams and choosing the various options to view the data in different ways.

Power BI Waterfall Month by Month example

Using Power BI’s Waterfall chart, finance data is plotted to show a month by month movement in income and in costs with the ability to look at the monthly trend for each cost. I bring in a small dataset, then perform a small amount of manipulation to the data before displaying the movement in Waterfall charts..

Power BI – Dynamic titles – Date, single selection, multi-selection

In Power BI, three examples of dynamically changing a page or chart header/title. Examples: Today’s date is added to a page; The page title updates based upon the single selection from a slicer; A chart title updates based multi-selection from a slicer.

Power BI – Plot cultural places on a map using an API and Open Data – Easy report to create

Using Open Data this project shows how easy it can be to pull data into Power BI using an API and displays the results on a map. A user then has the ability to filter the map and source a link to websites of interest.

Power BI – Comma separate numeric value in a text field

In Power BI you have text as the title to a page or diagram and within that text is a numeric value. You would like the value to be comma separated. This video shows you how easy this can be to fix.

Power BI – Card visual – (Blank) to Zero – Implicit to Explicit measure

In Power BI, change from (Blank) to the number zero in a card visual by using a measure.

In R dataframe – how to alter the number of observations and/or variables

In R dataframe – how to alter the number of observations and/or variables.

Create a Wikidata Query – example using Shipwrecks data

A follow along example of creating a query in Wikidata. Here, the data of where ships are considered to have been wrecked off the coast of Scotland, UK has been used. Wikidata query created in the video can be found at here.

Bring Wikidata into Power BI using a simple R script – example

A follow along example – Coordinates from Wikidata are brought into Power BI for plotting on a map using a simple R script. The data used in this example is where ships are considered to have been wrecked off the coast of Scotland.

SWITCH() to change the background colour in a Power BI table

Using a DAX SWITCH function to change the background colour of a cell in a Power BI table. In this video I provide an example of the cell colour changing based upon the number of dates to a project deadline.

Power BI – Append – walk through example using Open Data

Join two different datasets with similar type of content using Append in Power BI. Here, two open data datasets relating to places in Dundee, Scotland, UK have had their rows combined together into one table using Append.

Power BI – Add symbols and emojis

For Power BI a follow along example explaining how symbols and emojis can be added to a report. After a short demonstration adding
symbols, attention is turned to creating a medals table based upon the ranking of profits.

Power BI – Create Treemap using Open Data – Easy follow along project

In Power BI, an open dataset it used to create a Treemap and Slicers. A small amount of data tidying and manipulation is undertaken to allow the treemap visual to be created.

Power BI – How to navigate line diagrams (line charts) – Introduction

Are you new to using Power BI reports? Here’s a few tips on how to navigate line diagrams (line charts).

Map Wikidata in an R Shiny App – example

A follow along example to map wikidata in an R shiny app. The data relates to where ships are considered to have been wrecked off the coast of Scotland. The map is OpenStreetMap using a leaflet package.

Power BI hyperlinks – link to webpage URL – chain and underline methods

Two methods of creating a link from contents on Power BI to a webpage (URL). The first creates a chain link symbol for redirect to a webpage/URL, the second creates an underline/underscore to a word or phrase to act as a redirect to the webpage/URL.

Insert Wikipedia extracts into a Power BI report using an easy API request- example

A simple Wikimedia API request is used to pull Wikipedia extracts into a Power BI report. In this follow along example, a slicer is created to hold the name of ships, an image of the relevant ship is pulled in from Wikimedia Commons, and an extract relating to the ship is pulled in from Wikipedia.

Map direction of ship travel using AIS data in R Shiny app on a Leaflet map – follow along example

Automatic Identification System (AIS) open data is used to plot the direction of travel of ships on a map provided by leaflet inside an R shiny app. The data has kindly been openly provided by the Norwegian Coastal Administration.

Power BI – DAX function RANKX – Dense and Skip

Using the DAX function RANKX in Power BI, this video demonstrates the treatment of the next item in a rank after a tie – would you like the next rank position to be the continuous or would you prefer to skip that position and go to the next.

Using R code, merge 3 csv files using left joins in an R Script – follow along using open data

Using R code, take 3 separate csv files and merge them together using a left join to provide more user friendly information for an end user. Designed as a follow along video, using third party open data we bring in details of births in Scotland and add to that information the names of the hospitals where the births occurred along with the council areas in which the hospitals reside.

Power BI – Small Multiples Diagram (Chart) example

In Power BI a line diagram (line chart) is created, and then using a feature called Small Multiples the diagram is altered to contain many mini line diagrams before being filtered to make it more readable.

Pin It on Pinterest

Share This