Power BI | Intro to Visual Calculations | UFO Sightings Dataset | Video 8
In this video, we will use Power BI Desktop to create a report page.
1. We will first understand the basic concepts of Visual Calculations.
2. Create a report page that has 2 visuals. By clicking on the visual, we will then create two visual calculations: Running Sum and Percent of Grandtotal and format the values .
We will use UFO Sightings dataset from Tidytuesday R Repository
FYI: Periodically we will create additional report pages & add more videos using the same dataset so that we will create a dedicated playlist for all these videos.
2 Datasets:
https://github.com/rfordatascience/ti...
https://github.com/rfordatascience/ti...
More datasets @Tidytuesday R
https://github.com/rfordatascience/ti...
TIMESTAMPS
00:00 Intro to Visual Calculations
01:08 add a line chart visual to the report page
01:56 Select the visual and then click on the New Visual Calculation
02:16 Create couple of visual calculations using the templates (Running Sum & Percent of Grand total)
08:37 Copy the final line chart, paste in on canvas and then convert it into a table visual
09:48 Compare a measure with the new Visual Calculations
10:42 Recap and conclusion