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.
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.
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😀
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?
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
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?
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,
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??
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, 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.
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?
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)
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
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
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
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
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 ?
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
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.
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.
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.
Congratulations Bas, very witty and colorful. Thanks for sharing.
thx Isidre for watching! 🙂 hope it will come in handy
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!
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 ;)
Beautifully! I was looking for such a taget area since a long time. Thank you!
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!
u are master of power bi tunning
Just what I needed! Thanks a lot!
Thanks!! This is awesome, can't wait to try it out at work
Awesome! Very clever use of standard visual. Keep up the good work!
Excellent! This is so useful for applying SPC (Statistical Process Control) methods.
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
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!!!
Excellent, what a great solution, I have always wanted to have that type of graphics
thx Mateo! 😀
This was a helpful tutorial.. Will update here if this helps me with my case.
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.
Nice tip. Thanks, Bas.
Thanks for watching Richard!!! 😀
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!
Great! Thank you for the trick.
thank you Ramon for watching!!! 😊
This is fantastic, great video thank you!
:) thx for watching Sam!
Lurv this format!!! Thanx =)
Awesome 😊 thanks
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?
Outstanding!!!!!!!!!
😀 thank you!!!
Great instruction video. Thank you.
thank you Miguel!!! 😀
Great vid mate
glad you liked it! thx for watching! 😀
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 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
Super Cool , on my way for implementation
If only min and max could be formula based instead of static fix
Cheers
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! 🙂
Great video. Can also use this conditional formatting for the names of the X-axis (Jan, Feb, Mar, ...) ? Thanks
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?
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,
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
Well, this is a great trick.
Great Trick, really Helps. Thanks much :)
Neat vid, thanks for sharing!
thx for watching Ary! 😀
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??
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).
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!
Brilliant !!
Thanks Azhar!!! 😀
what version of Power BI are you using?
i can't find the property for the padding on the bars!
Amazing!
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 🤗😬
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.
What is the format of the "production volume"?
Boom... ✨ 👍👍👍👍
thx Peter 😀
Hellooo... Is there any way to fill the area bounded between 2 lines in line chart Or in any other visuals?
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!
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?
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)
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
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
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
Nice one!
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
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 ?
Awesome
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?
Very nifty.
thx Azzam 👊
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
Superrrrr!
I don't have the inner padding
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?
nice
BAS is the BOSS
haha :) check out the newer version of this video: th-cam.com/video/iTP7sMdY2Dw/w-d-xo.html
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)
Unfortunately this method is not working anymore on the newest power bi update.
💥💥🔥🔥
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
today's update makes this even easier?
Amazing!