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/dyn...
🎬 MORE VIDEOS:
Power BI Row-level Security - Complete Guide - • Power BI Row-level Security - Complete Guide
Power BI & Power Automate - How to automate reporting process - • Power BI & Power Automate - How to automat...
How to prepare for the DA-100 Exam - My journey, learning materials & what to expect - Power BI Tips - • How to prepare for the DA-100 / PL-300 Exa...
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 - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: https://bilingualanalytics.com.au/abo...
📍 – 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