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.
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.
thanks Amrita! if you are on the march 22 version or later you probably wanna check this video first th-cam.com/video/iTP7sMdY2Dw/w-d-xo.html .. it became a bit easier to create a chart like this😀
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?
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.
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?
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,
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
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
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).
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??
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.
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
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
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
yes, but then you can better use a different technique that I show in this video th-cam.com/video/PlMvvKEPgfA/w-d-xo.html (and then just set the width based on 3x st dev)
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?
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?
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 ?
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
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?
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 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] ))).
@@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
@@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?
@@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)
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
Hey Bryan, maybe check if there are borders. Another alternative would to take a different approach with an area chart -> th-cam.com/video/PlMvvKEPgfA/w-d-xo.html hope that helps
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.
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.
Just what I needed! Thanks a lot!
Beautifully! I was looking for such a taget area since a long time. Thank you!
Congratulations Bas, very witty and colorful. Thanks for sharing.
thx Isidre for watching! 🙂 hope it will come in handy
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.
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!
thanks Amrita! if you are on the march 22 version or later you probably wanna check this video first th-cam.com/video/iTP7sMdY2Dw/w-d-xo.html .. it became a bit easier to create a chart like this😀
@@HowtoPowerBI thank you! I will check it out!
Bas, this is great technique. I will be using this in my reports. Thanks so much!
Hey Scott, this is awesome that you find this usefull for your reports 😁Made my day!
Very nice tip! I'm from Brazil and I'm working as data analyst. Your videos are awesome and helps me a lot!
awesome, nice to hear that Lucas! greetings from Germany ;)
Excellent! This is so useful for applying SPC (Statistical Process Control) methods.
Awesome! Very clever use of standard visual. Keep up the good work!
Thanks!! This is awesome, can't wait to try it out at work
Excellent, what a great solution, I have always wanted to have that type of graphics
thx Mateo! 😀
u are master of power bi tunning
Nice tip. Thanks, Bas.
Thanks for watching Richard!!! 😀
This was a helpful tutorial.. Will update here if this helps me with my case.
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?
Very clever stuff, thanks for the video!
Hi Matthew, thanks for the comment! Glad you like it 😀
You are next level thanks a mil definitely using this.
Awesome Bas. Aways with good tips !!!! Congrats.
I will suggest you to make a video showing good things about charticulator !!!!
thank you for watching and the video idea!!!
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.
I guess you can go for small multiples for multiple countries and adapt the measure with variables to correctly select each country
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?
Super Cool , on my way for implementation
If only min and max could be formula based instead of static fix
Cheers
This is a great trick ... it almost let's you do conditional formatting for line charts, which is an important missing feature!
great solution, thank you very much💪
You are welcome 😁happy to hear you like it!
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!
Great video. Can also use this conditional formatting for the names of the X-axis (Jan, Feb, Mar, ...) ? Thanks
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,
Great! Thank you for the trick.
thank you Ramon for watching!!! 😊
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
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
@@hendrik-stack22 that is great! You gain a great visual tool with a small impact, it it very worthy.
Thanks for the follow up
thx for checking Hendrik-stack! 🙂
This is fantastic, great video thank you!
:) thx for watching Sam!
Great instruction video. Thank you.
thank you Miguel!!! 😀
Great Trick, really Helps. Thanks much :)
That's just what I was looking for. Wow!
There is also an easier way:
th-cam.com/video/iTP7sMdY2Dw/w-d-xo.html
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).
Lurv this format!!! Thanx =)
Awesome 😊 thanks
Outstanding!!!!!!!!!
😀 thank you!!!
Well, this is a great trick.
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??
Neat vid, thanks for sharing!
thx for watching Ary! 😀
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.
Amazing!
this trick is really cool!
happy to hear you like it Thành! 😀
@@HowtoPowerBI yes, you guys make some tricks I though I couldn't make in Power BI in the past, really awesome
Thank you 👍
👊 thx Bharat
That was brilliant!
thanks Gabriela! there is already a much easier way to do this: th-cam.com/video/iTP7sMdY2Dw/w-d-xo.html
Brilliant !!
Thanks Azhar!!! 😀
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?
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
Great trick, I will be using it. Why can't they just put stuff like this in on the standard visuals?
that would make life a lot easier ... till that time I guess we have to do it with work arounds like this one 🤗😬
Great vid mate
glad you liked it! thx for watching! 😀
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
what version of Power BI are you using?
i can't find the property for the padding on the bars!
Very cool trick, thanks for sharing! Quick question: what software do you use for recording and editing your videos? :D
thx!! camtasia / premiere pro
@@HowtoPowerBI Thanks, appreciated!
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
Hellooo... Is there any way to fill the area bounded between 2 lines in line chart Or in any other visuals?
Awesome
cool! but is there a way to apply 6sigma UPL and LCL
yes, but then you can better use a different technique that I show in this video th-cam.com/video/PlMvvKEPgfA/w-d-xo.html (and then just set the width based on 3x st dev)
Nice one!
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?
concatenate labels shows when you switch to categorical axis - you probably still r on continuous
@@HowtoPowerBI thanks fr ur reply... U r doing great
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?
What is the format of the "production volume"?
Superrrrr!
Boom... ✨ 👍👍👍👍
thx Peter 😀
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 ?
Very nifty.
thx Azzam 👊
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
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?
nice
💥💥🔥🔥
BAS is the BOSS
haha :) check out the newer version of this video: th-cam.com/video/iTP7sMdY2Dw/w-d-xo.html
Hi! How can I put a target area with lines and columns values?
Hi Dea, ooeh I think that's not possible yet with the current default visuals
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?
Yes, I have this same problem!! Any solution?
today's update makes this even easier?
Unfortunately this method is not working anymore on the newest power bi update.
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.
Could you post here the measure that doesnt work?
@@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] ))).
@@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
@@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?
@@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)
Can you please update this? It is no longer applicable to the latest version of power BI
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
Hey Bryan, maybe check if there are borders. Another alternative would to take a different approach with an area chart -> th-cam.com/video/PlMvvKEPgfA/w-d-xo.html hope that helps
Amazing!