Create a TARGET AREA for a Line Chart in Power BI | No Custom Visual

[@VishalVasishat-v7n]

Amazing tutorial, thanks for sharing. Just to add if we need gridlines as well we make transparency of white area to 100%, that will make white area completely transparent and gridlines will be shown.

[@benjaminlembke5934]

I am getting white lines in my target area even if I set inner padding to 0. Changing to categotical only is part of the solution for me. I still get white lines between every data point in the target area. Someone with similar problems?

[@hotshot11112222]

Yes, I have this same problem!! Any solution?

[@simon-ski]

Nice idea and good video, but please correct me if wrong: Disadvantages of this implementation are that y-axis must be fixed and cannot adapt dynamically (due to two axes). Moreover, the solution does not support the addition of multiple column values (as shown on 3:29). Hence, showing targets for example for multiple countries at the same time is not possible.

[@viniciuscabrera8759]

I guess you can go for small multiples for multiple countries and adapt the measure with variables to correctly select each country

[@philipedesouzasantos1201]

Unfortunately this method is not working anymore on the newest power bi update.

[@camillalandt835]

With the new opdate in powerBI i cannot find the inner padding and therefore not make my collums tightent with no space between, doyou know why og how ?

[@karlandersson2290]

What is the format of the "production volume"?

[@richardfinney2548]

Can you please update this? It is no longer applicable to the latest version of power BI

[@khyatipatni]

Just what I needed! Thanks a lot!

[@LowriderLowbro]

Bas, on 4:42 you slide the inner padding to 0, that option is not appearing for me, do you have any idea if this is a known bug ? i am on the latest version

[@physicalkaagent5430]

Great video! For changing the padding on the bars to get one connected target area: i created an extra columns in my pandas dataframe before exporting. results in the same target box as shown in the video, however i dont have the option to change padding on the x-axis. Is this because i dont use a power bi measure or could it have something to do with the recent update (feb 2022) that might no longer support this option?

[@raeesg]

today's update makes this even easier?

[@MatBR10]

Thanks!! This is awesome, can't wait to try it out at work

[@rerangelt]

Well, this is a great trick.

[@isidrebague3659]

Congratulations Bas, very witty and colorful. Thanks for sharing.

[@HowtoPowerBI]

thx Isidre for watching! 🙂 hope it will come in handy

[@scottwilliams6741]

Bas, this is great technique. I will be using this in my reports. Thanks so much!

[@HowtoPowerBI]

Hey Scott, this is awesome that you find this usefull for your reports 😁Made my day!

[@Diark-c9s]

Beautifully! I was looking for such a taget area since a long time. Thank you!

[@mateocasa6807]

Excellent, what a great solution, I have always wanted to have that type of graphics

[@HowtoPowerBI]

thx Mateo! 😀

[@apg360]

Magnífico vídeo, como siempre. He encontrado un problema. Cuando muevo la jerarquía de fechas, si subo a años, por ejemplo, no me funcionan los marcadores para resaltar valores atípicos. ¿Es así o he hecho yo algo mal? Mil gracias. Un cordial saludo,

[@subeenmathur7182]

Help needed on this. I want to plot the area chart from a coloum with different colours based on some conditions like if the value is going above 155 it will show the area in blue and below 20 it will show the area in Red. But when I am applying conditional formatting on y axis values, the option is only changing the y axis legend value's colur not the colour of area chart. Kindly help on this. Thanks in advance

[@abdulrahmanalnajjar1496]

thanks ....Really cool Is it possible to make a DAX equation that changes the color of 100% Stacked bar chart dynamically with the percentage of achievement

[@ymohamed3154]

Great video. Can also use this conditional formatting for the names of the X-axis (Jan, Feb, Mar, ...) ? Thanks

[@nahuelvalenzuela5143]

great solution, thank you very much💪

[@HowtoPowerBI]

You are welcome 😁happy to hear you like it!

[@wybohoekstra3511]

what version of Power BI are you using? i can't find the property for the padding on the bars!

[@finnwhale4219]

Unfortunately, PowerBI no longer gives the option to set the inner padding. Is there any work around to merge the bars to one continuous shape?

[@janrosenbaum9539]

Hey Bas, i can't seea any download link for this example like in other videos. do you have any link for me? Great Video as usual!

[@sh3ll451]

Very clever stuff, thanks for the video!

[@HowtoPowerBI]

Hi Matthew, thanks for the comment! Glad you like it 😀

[@tomoyat5517]

Wow. Very creative! And the way you write Dax while you talk and give a look at both camera and PC… I wish I could be! Thumbs up.

[@bosnianinny]

Excellent! This is so useful for applying SPC (Statistical Process Control) methods.

[@PhilippMader2407]

Hi, great trick! Does the conditional formatting also works with a hierarchy (so that the min and max value of the y-Axis change in case of drilldown or drillup)? At least I am not able to get it running. I tried the DAX function isonscope but it seems as if this doesn't work as a conditional format for the y-axis.

[@AmritaOSullivan]

This is such a cool idea and really helps us think outside the box!!! I’m doing this tomorrow morning, it totally ups the visualisation game!

[@HowtoPowerBI]

thanks Amrita! if you are on the march 22 version or later you probably wanna check this video first kzbin.info/www/bejne/n4WzaKaDmb5letk .. it became a bit easier to create a chart like this😀

[@AmritaOSullivan]

@@HowtoPowerBI thank you! I will check it out!

[@alpesh417rt]

Super Cool , on my way for implementation If only min and max could be formula based instead of static fix Cheers

[@yaswanthbylapudi]

Great Trick, really Helps. Thanks much :)

[@sarabdn2068]

Hi, Thank you for this video! Looking very good. I have an issue with highlighting the outliers. When writing the measure, the variable (in your case production value) can not be found. For this reason I get a red line under this variable and the syntax is incorrect. Can you help me??

[@sangeethaezhumalai168]

Hellooo... Is there any way to fill the area bounded between 2 lines in line chart Or in any other visuals?

[@MrAszpic]

Neat vid, thanks for sharing!

[@HowtoPowerBI]

thx for watching Ary! 😀

[@vicmartal]

Amazing!

[@mustafabiviji00711]

This is a great trick ... it almost let's you do conditional formatting for line charts, which is an important missing feature!

[@RKB_1]

Great video, thanks a lot. I want to use these steps for creating control charts. Do you have any specific tutorials for creating control limits like a SPC chart?

[@leokapere]

nice

[@MillexD66]

This is genius! Thanks a lot :-) What if I have several lines (ex sales YTD and sales LYTD) and I want to keep the measure explanation - but only for the data that the lines represent? Right now I see four measure explanations on the top of my chart (sales YTD, sales LYTD, target area lower limit and target area - height).

[@impala4641]

Great content! Have you checked if this visual has any impact on the report performance? It seems like is doing a lot for showing everything, specially if there is a lot of data. Also, could you consider showing your face on a corner and just leave it there, a lot of time we get to see you when we might want to be seeing the screen full of the visual and the panels instead

[@hendrik-stack22]

Hey Impala, i checked it. My report performance changed by 5%. Loading time went from 1624ms to 1705 (2 attempts). So it didnt really get much bigger. Regards Hen

[@impala4641]

@@hendrik-stack22 that is great! You gain a great visual tool with a small impact, it it very worthy. Thanks for the follow up

[@HowtoPowerBI]

thx for checking Hendrik-stack! 🙂

[@giuseppeclaudioperrotta6449]

Superrrrr!

[@ramonillarramendi3191]

Great! Thank you for the trick.

[@HowtoPowerBI]

thank you Ramon for watching!!! 😊

[@sangeethaezhumalai168]

Looks cool... But am not getting some options...like concatenate labels... And also if I set inner padding to 0,the gaps are not filling...is it the mistake from my side or Microsoft bug?

[@HowtoPowerBI]

concatenate labels shows when you switch to categorical axis - you probably still r on continuous

[@sangeethaezhumalai168]

@@HowtoPowerBI thanks fr ur reply... U r doing great

[@hotshot11112222]

I am having the same issue with inner padding. Continuous and categorical both have the same issue - there is still a very small gap between bars. Has anyone found a fix?

[@RichardOliver]

Nice tip. Thanks, Bas.

[@HowtoPowerBI]

Thanks for watching Richard!!! 😀

[@chaitanya38419]

This was a helpful tutorial.. Will update here if this helps me with my case.

[@keagankemp6275]

You are next level thanks a mil definitely using this.

[@EdwinVeenboer]

Somehow your channel is not my nr1 goto place on the internet to find answers, but almost every time i end up finding the solution to my specific problem on your channel. Absolutely love your content.

[@Pjotterbolte]

Awesome! Very clever use of standard visual. Keep up the good work!

[@bitips]

Awesome Bas. Aways with good tips !!!! Congrats. I will suggest you to make a video showing good things about charticulator !!!!

[@HowtoPowerBI]

thank you for watching and the video idea!!!

[@lape36]

Thanks Baris Thanks Bas, Awesome trick. How can I get this to work if I've multiple lines like 2 or 3 categories I want to compare?

[@HowtoPowerBI]

thx Lars! 😀 you would need to create separate measures for the value per category and then put them on line values (you can't simply put category on legend using this technique). So for example measure 1: Sales EU = CALCULATE(SUM(Sales), Region = "EU") , measure 2: Sales US = CALCULATE(SUM(Sales), Region = "US") --> put them on line values

[@hotshot11112222]

Does anyone else have an issue where setting inner padding to 0 doesn't remove the space between bars? The space becomes small, but it is still visible, making for a very ugly chart

[@HowtoPowerBI]

Hey Bryan, maybe check if there are borders. Another alternative would to take a different approach with an area chart -> kzbin.info/www/bejne/hp2wp6mBerWanKM hope that helps

[@lucasfrancisco1502]

Very nice tip! I'm from Brazil and I'm working as data analyst. Your videos are awesome and helps me a lot!

[@HowtoPowerBI]

awesome, nice to hear that Lucas! greetings from Germany ;)

[@就已]

u are master of power bi tunning

[@jonesPossibly]

Great trick, I will be using it. Why can't they just put stuff like this in on the standard visuals?

[@HowtoPowerBI]

that would make life a lot easier ... till that time I guess we have to do it with work arounds like this one 🤗😬

[@nvprophecy]

cool! but is there a way to apply 6sigma UPL and LCL

[@HowtoPowerBI]

yes, but then you can better use a different technique that I show in this video kzbin.info/www/bejne/hp2wp6mBerWanKM (and then just set the width based on 3x st dev)

[@spen2431]

Boom... ✨ 👍👍👍👍

[@HowtoPowerBI]

thx Peter 😀

[@Soulenergy31]

Outstanding!!!!!!!!!

[@HowtoPowerBI]

😀 thank you!!!

[@alicevoiss871]

I know I am doing something simple incorrectly - but the new measure for the highlight outliers will not let me select the production volume data into the code.

[@HowtoPowerBI]

Could you post here the measure that doesnt work?

[@alicevoiss871]

@@HowtoPowerBI it is my monthly production volume field from the source - it will not let me add it to the formula.- Tried to create a measure from the field and it doesn't like that either. Highlight Outlier = VAR LowerLimit = [Target Area - Lower Limit] VAR UpperLimit = LowerLimit + Sheet1[Target Area - Height] VAR Result = If( [m_Production Volume]UpperLimit, [m_Production Volume] ) Here is the measure i created for the column m_Production Volume = MEDIAN('Sheet1'[Production Volume]) Error message: The syntax for ')' is incorrect. (DAX(VAR LowerLimit = Sheet1[Target Area - Lower Limit]VAR UpperLimit = LowerLimit+Sheet1[Target Area - Height]VAR Result = IF( [m_Production Volume]UpperLimit, [m_Production Volume] ))).

[@HowtoPowerBI]

@@alicevoiss871 Highlight Outlier = VAR LowerLimit = [Target Area - Lower Limit] VAR UpperLimit = LowerLimit + [Target Area - Height] VAR Result = IF ( [m_Production Volume] < LowerLimit || [m_Production Volume] > UpperLimit, [m_Production Volume] ) RETURN Result

[@alicevoiss871]

@@HowtoPowerBI I see - if you could - keep the final code on screen for just one/two seconds longer before clicking off. I did not add the Return Result code. Also - for those of us newbies that did not know you cannot add a column to and IF statement - would be nice to have that heads up and steps to address. Is that in another video?

[@HowtoPowerBI]

@@alicevoiss871 you can pause the video. Alternatively you could also download the file and copy it from there. I don't have any videos that cover all the fundamental concepts on youtube - you do find them in the howtopowerbi learning path (see link in description)

[@azzamsiddiqui9510]

Very nifty.

[@HowtoPowerBI]

thx Azzam 👊

[@Bharath_PBI]

Thank you 👍

[@HowtoPowerBI]

👊 thx Bharat

[@deanajera6339]

Hi! How can I put a target area with lines and columns values?

[@HowtoPowerBI]

Hi Dea, ooeh I think that's not possible yet with the current default visuals

[@samcrowson167]

This is fantastic, great video thank you!

[@HowtoPowerBI]

:) thx for watching Sam!

[@nicolasramos3862]

That's just what I was looking for. Wow!

[@HowtoPowerBI]

There is also an easier way: kzbin.info/www/bejne/n4WzaKaDmb5letk

[@azharshaik21]

Brilliant !!

[@HowtoPowerBI]

Thanks Azhar!!! 😀

[@ThanhNhandl]

this trick is really cool!

[@HowtoPowerBI]

happy to hear you like it Thành! 😀

[@ThanhNhandl]

@@HowtoPowerBI yes, you guys make some tricks I though I couldn't make in Power BI in the past, really awesome

[@MiguelMartinez-sh8gz]

Great instruction video. Thank you.

[@HowtoPowerBI]

thank you Miguel!!! 😀

[@lifesgood8294]

BAS is the BOSS

[@HowtoPowerBI]

haha :) check out the newer version of this video: kzbin.info/www/bejne/n4WzaKaDmb5letk

[@PowerBIFerryTales]

Nice one!

[@fabriziocau4085]

Very cool trick, thanks for sharing! Quick question: what software do you use for recording and editing your videos? :D

[@HowtoPowerBI]

thx!! camtasia / premiere pro

[@fabriziocau4085]

@@HowtoPowerBI Thanks, appreciated!

[@tontolim1043]

Lurv this format!!! Thanx =)

[@HowtoPowerBI]

Awesome 😊 thanks

[@vicmartal]

Amazing!

[@deepakrathor4558]

Awesome

[@Fiktage]

💥💥🔥🔥

[@gabrielabarrera1983]

That was brilliant!

[@HowtoPowerBI]

thanks Gabriela! there is already a much easier way to do this: kzbin.info/www/bejne/n4WzaKaDmb5letk

[@oddy3340]

Great vid mate

[@HowtoPowerBI]

glad you liked it! thx for watching! 😀