2021 Week 23 | Power BI: Can You Build a Cumulative Line Chart?
source link: http://www.workout-wednesday.com/pbi-2021-w23/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Introduction
Continuing with the Nobel Prize data that Meagan began exploring last week, this week extends to consider aspects of individual Nobel laureates. The main visual is a cumulative line chart, but you’ll also provide detail on laureates with a report page tooltip.
While additional JSON expansion and transformation was required from the original dataset, this week goes a bit easier on Power Query and provides a relatively clean (but not completely clean) dataset posted to Data.World.
The challenge this week builds upon some basic DAX seen in prior challenges, optionally explores Quick Measures, and then requires you to use DAX to create a measure where it might initially be tempting to create a separate column.
Using the countries of birth (or modern equivalents provided in the “now” column), this challenge allows you to better explore the geographical diversity of laureates over time.
The text on the embedded version is difficult to read, so use the arrow icon in the lower right corner to expand to full screen.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK