How to Make Line Chart Average Range in Power BI

In this video I show how you can make a range for your averages in a line chart. It's not directly available in Power BI but with a little trick you can easily do it.

⬇️ Download Power BI file:
https://drive.google.com/drive/folder...

Data Source:
https://www.kaggle.com/datasets/prase...


📸 IG:   / yourownkpi  
🖼️ Dribbble: https://dribbble.com/YourOwnKPI
👨‍💼 LinkedIn:   / zsolt-szabo-bln  


Since many of you asked how I learn Power BI, here are some books I vouch for. I like to learn from books, because they provide a complete structure and they answer many questions I didn't even know I need to ask (not only as a beginner). I didn't read all of them form cover to cover yet but they gave me great value already nonetheless.

Amazon links to the books*:
📕 Data visualization
● Storytelling with Data https://amzn.to/3RDAh1J
It is my #1 recommendation. If you don't read anything else, just read this and you will be ahead of the majority of the Power BI developers in dataviz.
● The Big Book of Dashboards https://amzn.to/3PGU3XJ
It is another great book and ithas many use cases if you want to dive deeper.

📘DAX
● Supercharge Power BI https://amzn.to/3Pw179u
A great book for beginners, covers the most crucial DAX topics.
● The Definitive Guide to DAX https://amzn.to/3rAgGF7
The holy book of DAX, but more advanced.

📗Power Query & Data Modeling
● Master Your Data with Power Query https://amzn.to/3ZJWFZy
This book gets you started very quickly with Power Query and ETL.
● The Data Warehouse Toolkit https://amzn.to/3thz7Py
Data modelling is so important. Better data model = simple DAX and faster reports! Read the first 2 chapters to get the basics. Dive eeper into specific chapters later on.

* These are Amazon affiliate links which provide a small commission to this channel via anything purchased via these links



⌚ Timestamps
00:00 Intro
00:34 The most important data only
10:54 Trend over time
17:22 Change across subcomponents
25:09 Details
32:00 Outro

#yourownkpi #yokpi