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:
drive.google.com/drive/folder...
Data Source:
www.kaggle.com/datasets/prase...
📸 IG: / yourownkpi
🖼️ Dribbble: 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 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 amzn.to/3PGU3XJ
It is another great book and ithas many use cases if you want to dive deeper.
📘DAX
● Supercharge Power BI amzn.to/3Pw179u
A great book for beginners, covers the most crucial DAX topics.
● The Definitive Guide to DAX amzn.to/3rAgGF7
The holy book of DAX, but more advanced.
📗Power Query & Data Modeling
● Master Your Data with Power Query amzn.to/3ZJWFZy
This book gets you started very quickly with Power Query and ETL.
● The Data Warehouse Toolkit 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

[@lubomirjagersky7327]

Very nice solution, I like your way of work and feelings for details

[@yourownkpi]

thanks :D

[@nicemovies99]

Thank you again for yet another banger video!

[@marquuezin]

You are the best! 🎉 thank you 🙏🏻

[@yogeshwaskar1719]

Awesome