Dynamic Time Period Comparison With Power BI

It could be difficult to analyze data for newly introduced products. In many cases we don't have lots of historical data, we don't have a plan for this year, so what can we do to provide the best possible data visualization in Power BI for our report users?

While this technique is not super difficult to set up, it involves a couple of little tricks to get it up and running and to make sure that it provides a great user experience.

I hope that you will be able to learn something new from this and you can implement this in your reporting suit.
Have a good one,
Roland

💪 New videos coming every Tuesday 🤹‍♂‍
🤘 New short videos coming every Friday 👨‍🏫

📝 BLOG POST: https://bilingualanalytics.com.au/dynamic-time-period-comparison/

🎬 MORE VIDEOS:
Power BI Row-level Security - Complete Guide - https://youtu.be/DNr7RIxRSBo

Power BI & Power Automate - How to automate reporting process - https://youtu.be/F5vn51ho6wk

How to prepare for the DA-100 Exam - My journey, learning materials & what to expect - Power BI Tips - https://youtu.be/8U5wn4Fgi6Q

Chapters:
00:00 Intro
00:20 Topic Of The Day
01:35 What's In The Report
02:42 DAX Measures
03:50 DataViz - 1
04:36 DataViz - 2
04:55 Dynamic Title
05:25 Rolling Average
05:46 DAX Trick
06:37 Conditional Coloring
07:17 X-Axis Constant Line
07:40 X-Axis Constant Line FIXED
08:44 Dynamic Time Period
09:19 Page Level Filter
09:48 No of Days Change
10:34 Best DataViz Practice
11:10 Pick Your Date
11:58 Summary
12:50 Download File
13:05 End

▼▼▼▼▼▼▼▼▼

Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.

▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - https://www.linkedin.com/company/bilingualanalytics/
Twitter - https://twitter.com/BILAnalytics
Subscribe - https://www.youtube.com/channel/UCxJmWVbKVLIQ3PrmJzR535A?sub_confirmation=1
ABOUT ME: https://bilingualanalytics.com.au/about-me/
📍 – Sydney, Australia

📽 GEAR:
📷 – Canon EOS 200D
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light
🎧 – BOSE QC35
🖥 – 2x ASUS VC279H
💻 – AMD Ryzen 5900, NZXT N7, RTX 3060 Ti, Team T-Force ARGB 64GB RAM

Music: www.bensound.com

#PowerBI #DataViz #TimeIntelligence #BILingualAnalytics

Видео Dynamic Time Period Comparison With Power BI канала BI-Lingual Analytics