Power BI

Line chart with vertical reference line

2022 Week 03 | Power BI: Can you visualize percent difference from a selected date?

Introduction This week we are taking a page from the Tableau team and looking at how a metric has changed from the value at a specified reference date.  Requirements Create a line chart showing percent change of the close price from a selected date.  Use a slicer or other visual to allow users to change […]

2022 Week 03 | Power BI: Can you visualize percent difference from a selected date? Read More »

2022 Week 02 | Power BI: Simplified Custom Page Navigation

Introduction Welcome back to Power BI #WorkoutWednesday – week 2! We had incredible participation last week and are so excited to dive in this week with custom page navigation. If this sounds familiar, it’s because we did a similar navigation challenge back in November 2021. In a fortunate turn of events, the Power BI team

2022 Week 02 | Power BI: Simplified Custom Page Navigation Read More »

2021 Week 47 | Power BI: Custom Line Chart Formatting

Introduction This week we are continuing our design theme by working through a custom formatting hack for line charts. Conditional formatting in Power BI can be tricky at times, especially when trying to format different chart types.  If you are familiar with conditionally formatting a line chart, you’ll know that in the Data Colors section

2021 Week 47 | Power BI: Custom Line Chart Formatting Read More »

A power bi report that calculates contrast ratio between two colors

2021 Week 46 | Power BI: Create a Color Contrast Calculator

Introduction This week we are continuing our design theme by making a report about report design. Color is a very important element in report design. Color contrast is not only important for accessibility, it’s also an element of visual hierarchy. You can also use color contrast as a way to make elements on your report

2021 Week 46 | Power BI: Create a Color Contrast Calculator Read More »

2021 Week 45 | Power BI: Create a Custom Navigation Experience

Introduction We hope that you had a lot of fun last week re-designing Spencer’s report! This week we’re also focusing on design and creating a custom navigation experience using bookmarks and buttons.  I am looking for a new place to live and stumbled upon the 2017 State of American Well-Being report. This PDF report details community well-being

2021 Week 45 | Power BI: Create a Custom Navigation Experience Read More »