Тёмный

Finally! Add a TARGET AREA in an Easy Way 

Подписаться
Просмотров 28 тыс.
% 888

In this video I show you how to add a target area to a line chart using error bars. This latest feature of the March 2022 update opens many useful visualization options you really want to know.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powerbidesigntransformation
Power BI Essentials datatraining.io/powerbilearningpath
Business User Training datatraining.io/powerbi-business-users
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:41 Static Target Area
02:38 Absolute Dynamic Target Area
03:44 Relative Dynamic Target Area
05:25 Formatting the target area
06:52 Incorporating what-if parameters
08:23 Adding dynamic labels
12:03 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta howtopowerbi
LinkedIn www.linkedin.com/in/basdohmen/
TikTok www.tiktok.com/@how.to.power.bi
X HowToPowerBI
fb groups/howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referral/8pjcbj
🚀 For growing on RU-vid: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Наука

Опубликовано:

 

23 мар 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 50   
@ronaldtijssen7492
@ronaldtijssen7492 2 года назад
Wat een perfecte timing. Ik was juist bezig met de workaround uit het eerdere filmpje toen ik een melding kreeg dat dit filmpje online staat 😁👍🏻.
@charlesabboud1613
@charlesabboud1613 Год назад
This video is extraordinary, fantastic content but also so well explained and produced. Completely professional!
@stuartmccloud307
@stuartmccloud307 2 года назад
Awesome, thanks, this is amazingly helpful :)
@MSFT_ScottSewell
@MSFT_ScottSewell 2 года назад
Great idea - and a great explanation! Well done.
@luca75tubo
@luca75tubo 2 года назад
Great video! Thanks!!!
@viniciusfernandes3552
@viniciusfernandes3552 2 года назад
That is a charm! cheers! Thanks!!!
@syedyakub5849
@syedyakub5849 2 года назад
Awesome, Thank you bas..
@tllittle
@tllittle 2 года назад
Thanks 👍🏽
@stiva22
@stiva22 2 года назад
Thanks
@unnikrishnansanthosh
@unnikrishnansanthosh Год назад
Class, one more master stroke from BAS, thanks for sharing
@sudharaniaryasomayajhula1265
@sudharaniaryasomayajhula1265 2 года назад
wonderful effort, your videos are very information and contented, i m big fan of your power Bi content! Thank you for educating Me(Us) Cheers
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Happy to hear that Sudharani! :)
@slimmammou893
@slimmammou893 2 года назад
Great thank you BAS , how to add different target areas in the same graph (red, yellow, green based on value)
@jamiedaly8940
@jamiedaly8940 2 года назад
I have a table with Forecasts & Actuals (both numeric columns) - however, when I attempt to create the 'Forecast -10%' & 'Forecast +10%' measures, it does not allow me to add "Forecast" to the formula - I notice both your "Sales - Actual" & "Sales - Forecast" are calculated measure - My "Forecast" & "Actual" are numeric columns - does the formula bar for new measures only accept calculated measures (and not numeric columns from a table)?
@gnavarrolema
@gnavarrolema 2 года назад
¡Gracias!
@PedroCabraldaCamara
@PedroCabraldaCamara 2 года назад
Very good Bas, AMAZING WORK!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Glad you enjoy it Pedro!
@egbertdejong6377
@egbertdejong6377 2 года назад
As always great content!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Much appreciated Egbert!
@alinc2527
@alinc2527 2 года назад
Another great video!!! Thanks
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thanks for watching!
@cg24356
@cg24356 2 года назад
Awesome
@maryampour8914
@maryampour8914 2 года назад
Great content. Thanks 😊
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Glad you liked it Maryam!
@RehanShaikh-ip9hh
@RehanShaikh-ip9hh 2 года назад
Very well explained.. Thanks
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Rehan, I am glad it was helpful!
@matthewdufty606
@matthewdufty606 Год назад
Excellent Video. I will get on this right now ⭐
@HowtoPowerBI
@HowtoPowerBI Год назад
Awesome 😎🙂 hope u have it up and running
@joserafaelfarfanfernandez899
Bas what about if I want to compare my sales with the previous month ? Thanks for all your content is awesome
@FacekiandaKianda
@FacekiandaKianda 2 года назад
You're the best!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
thanks! :) glad you are enjoying the videos
@saharadi4535
@saharadi4535 Год назад
please make a video how to create a horizontal bullet chart that shows variance
@southpaww
@southpaww 8 месяцев назад
I can't find the answer, maybe I'm searching with the wrong terms. I have a stacked column chart showing number of surveys received, by survey Language - one column per school location. I need to add a target per column of the max possible surveys that could be recieved at that school. I can't figure out how to do this! I'm using a stacked column with line, but I only get the constant line as an average for all data, and not one relative to the column/school. Any thoughts? Could really use some help!
@hishnick79
@hishnick79 2 года назад
Yeap, I’ll get the training bro! goodstuff
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thx!
@totvabe1
@totvabe1 2 года назад
Nice, nice, nice.
@tubeitz
@tubeitz 2 года назад
amazing!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thanks Varun!
@digitama
@digitama Год назад
Im an Data analytics and my boss told me to watch your video so I now subscribe
@HowtoPowerBI
@HowtoPowerBI Год назад
thanks for the sub! 😀
@digitama
@digitama Год назад
@@HowtoPowerBI also I like to know if you can unstack a stacked column using Power Bi ?
@sharanyhakarthikeyan4172
@sharanyhakarthikeyan4172 2 месяца назад
Awesome video! Hi, I am looking for a solution. I like to build up with line chart with Target and Actual (two lines in a chart) Actual is live and I used quick measur Year to date, I have only targeted value eg. 10 million I want to build the line chart, Target line as diagonal from 0 to 10 million and Actual line chart. Could you help me with this please?
@MrJornee
@MrJornee 2 года назад
Nice! Great video, thanks!
@alicedwonderland7733
@alicedwonderland7733 2 года назад
Bas, any chance for a video on custom icons? Pleaseee
@yassirkhalid5376
@yassirkhalid5376 2 года назад
Another great video for a great feature! But I have two questions: 1. Why for the lower bound you multiplied by -10%? I thought it should be 90%! 2. Is there is any way to reduce the number of measures? For example, lower and upper in just one measure, or at least if I have another forecast for quantity, can I just make one measure and use the switch to select the right variable for each graph?
@alexwu4738
@alexwu4738 2 года назад
why i cant download the pbi files anymore?
@HowtoPowerBI
@HowtoPowerBI 2 года назад
hi Alex, sure you can. just register here: my.datatraining.io/course?courseid=howtopowerbifiles
@LJ-jd5yy
@LJ-jd5yy 2 года назад
You look like John Krasinski
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Haha, interesting, my wife agrees :) Guess it is a good thing? ;)
@Iamcorky12
@Iamcorky12 2 года назад
Great video, thanks !