From the course: Power BI Data Visualization and Dashboard Tips, Tricks, and Techniques
Unlock this course with a free trial
Join today to access over 24,700 courses taught by industry experts.
Compare table and matrix visuals - Power BI Tutorial
From the course: Power BI Data Visualization and Dashboard Tips, Tricks, and Techniques
Compare table and matrix visuals
- [Instructor] Did you know that you can use Power BI to create a colored grid similar to this co-occurrence matrix? Matrices in Power BI let you drill down conditionally color and show cross-tabular data. So let's explore. Now, let's create a new tab called Table because a matrix in Power BI is just a type of table. And then let's click on Table so that we can compare between the two. Tables are exactly what you would expect. They are lists of data, and the data aggregate by default. So if we pull in Product, and then Profit. For example, let's say average profit, we just see six rows and a total, which in that case actually is not a total, it's an average, but still. And then if we drag Date in there, we see more rows because Power BI is trying to give us the least meaningful data for what we have requested it. It's always grouping in a table. It can always be useful actually to add any column and just make that a count. It's not relevant that it's a count of sales, it's just a row…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Understanding the publishing workflow4m 2s
-
(Locked)
Mastering bar charts in Power BI6m 2s
-
(Locked)
Drilling down line charts with date hierarchies7m 11s
-
(Locked)
Display single numbers with KPIs, new card visuals, and gauges6m 23s
-
(Locked)
Showcase proportion data with pies and treemaps6m 43s
-
(Locked)
Visualize distribution data with histograms and scatterplots7m 26s
-
(Locked)
Use maps and choropleths with confidence7m 2s
-
(Locked)
Compare table and matrix visuals6m 33s
-
(Locked)
Use custom visuals to solve unmet requirements3m 45s
-
(Locked)
Challenge: Create a report showing trends in profitability2m 44s
-
(Locked)
Solution: Create a report showing trends in profitability6m 53s
-
-
-
-