Power BI: Sparklines!
Create a report using sparklines in table and matrix visuals.
Part of the Power BI Work Out Wednesday Challenges, reference below.
Data Source:
Connect to Data.World here.
Challenge Requirements
- Download the data file from the link above. We are just using the Orders table in this challenge.
- Make sure you have the December 2021 Power BI Desktop release (or later) installed.
- Make sure that Sparklines are turned on in your Preview Features.
File -> Options and Settings -> Options -> Preview Features -> Sparklines - Create four different tables that feature sparklines
1. Make a table that includes at least one field. In my example I used Category and Segment. Create a sparkline that shows Sales by Month of Order Date
2. Using the same table created in step one, format the sparkline by changing the Data color as well as where you show the markers. Change the stroke width as well
3. Using the table created in step 2, transition the spark lines to columns. This will show the spark lines as bars instead of a line chart.
4. Create a matrix that has one field as the Rows and one as Category, the fields you use are up to you. Create two different Sales sparklines, one by Order Date and the other by Ship Date. Make one of them a line and the other a column chart. Make sure to add in some formatting on both sparklines.
Reference: https://www.workout-wednesday.com/2022/01/05/pbi-2022-w01/