In this video, we will use Power BI Desktop to create a report page.
We will use the New Card Visual and Text Slicer Visual (November 2024 feature updates)
1. We first will create a Column from a disconnected table and then create 4 measures.
2. We will review the 3 new feature updates for Reporting : Visual Calculations, New Card Visual with small multiples and Text Slicer
3. We will then create a report page that has a Table Visual and the New Card Visual and Text Slicer.
The values will change dynamically based on the user selections.
We will use 2 datasets, UFO Sightings dataset and Places.csv from the Tidytuesday R Repository
FYI: Periodically we will create additional report pages & add more videos using the same datasets 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 Table Relationships overview in the Model View of PBI Desktop
01:25 How to create a new column in Table A by using values from a disconneted Table B
04:23 Write code and test it using 'Dax Query View'
05:19 Start creating a report page and create a few measures
08:44 Overview of November 2024 feature summary ( Reporting section)
09:50 Visual Calculations (new added feature export data enabled)
10:42 Small multiples for the new card visual
13:03 Text Slicer Overview
14:33 Recap and conclusion