Microsoft Power BI

Microsoft Power BI community sharing our Power BI experience, tutorials, use cases, tips and…

Follow publication

Member-only story

Using Time Periods as Slicers to Enhance Power BI Line or Area Charts’ Range

Isabelle Bittar
Microsoft Power BI
Published in
5 min readDec 13, 2023
By Isabelle Bittar for KI Data Science

PBIX file available for download at the end of this article.

Introduction

The flexibility to choose a specific time frame for data visualization can be very helpful, especially in domains like stock/asset data analysis. This feature, commonly seen in platforms like Google Finance and CoinMarketCap, allows users to tailor their data analysis to specific periods, offering more targeted insights.

Examples From Google Finance and CoinMarketCap

In this article, I’ve utilized data from Investing.Com to create the visuals showcased in the cover image. I will guide you through the detailed steps to replicate these visuals in Power BI. Below is a glimpse of the Stock Data table loaded into Power BI, which forms the basis of our analysis:

Excerpt of the Stock Data Table in Power BI

Create an account to read the full story.

The author made this story available to Medium members only.
If you’re new to Medium, create a new account to read this story on us.

Or, continue in mobile web

Already have an account? Sign in

Microsoft Power BI
Microsoft Power BI

Published in Microsoft Power BI

Microsoft Power BI community sharing our Power BI experience, tutorials, use cases, tips and tricks. Learn together. Grow together. Follow our Power BI Masterclass: https://linktr.ee/powerbi.masterclass or me: https://linktr.ee/tomas.kutac

Isabelle Bittar
Isabelle Bittar

Written by Isabelle Bittar

Isabelle is a Montreal-based business consultant specialized in data science.

Write a response