Gracias por este contenido de alto nivel . Luego de 3 largas horas logre completar el ejercicio . Ahora tengo que traducirlo al español para compartirlo con mis alumnos. La gente de Zebra e Inforiver deben estar asustados de que este post llegue a todo el publico jeje .
great Park, thanks for sharing your knowledge. I need your help, with the measures_5 delta py line negative and positive. In your case you use 3 base measures including the forecast one, in my data set, there would only be 2, kwh ac and kwh py, but when trying to replicate the delta py line neg and pos means, the bars do not appear, could you help me with the logic of the dax formula? without taking into account the measure of the fc forecast.
So this isn't really possible right now as is, because the error bars unfortunately don't have the formatting option to change display units. Honestly, if it was a make or break situation, I would use the same steps that I do to make the transparent bars for the relative % bars, and modify the values there. You would need to use this: Delta PY Vals = IF([_5 Delta PY] < 0,[_5 Delta PY Line]* 0.92 + [_5 Delta PY], [_5 Delta PY Line] + [_5 Delta PY])
@@PowerBIPark Cool, I mean order they way we see the info, in your example the order is by month, Jan - feb - mar etc....but if I want to order by perfentage? From the highest to the lowest percentage?
Henstly this is crazy that someone need to almost hack BI in order to do this kind of visual. Way to complicated. I wish You did not skip through measures creation (with paste via dax query editor) as this is the important part i guess and the main idea.
I hear you, the amount of effort is a bit much, but there are other options like zebra bi or inforiver. Thanks for feedback, but most of the DAX I go into at length in the video so hopefully that helps
![[IBCS] Advanced Power BI Tutorial - Native Column Chart](http://i.ytimg.com/vi/jvJd-Vqa8EU/mqdefault.jpg)
![[IBCS] Advanced Power BI Tutorial - Native Column Chart](/img/tr.png)
Dear Park, I recommend your post on Linkedin every time I can. You rock, you are very clear explaining. Thaks from Argentina
Thanks Hernan. I really hope my videos help you do better professionally 😊
Gracias por este contenido de alto nivel . Luego de 3 largas horas logre completar el ejercicio . Ahora tengo que traducirlo al español para compartirlo con mis alumnos. La gente de Zebra e Inforiver deben estar asustados de que este post llegue a todo el publico jeje .
I've put the pbix in the description, maybe it will help ☺
Love the content!
Is there a way to conditionally format the bars once overlapped?
Awesome by using native chart. previously have to use SVG. and really like this series of creating charts following IBCS
Thanks man, I really hope it helps you and others 😁
This would be amazing to enhance the Power BI dashboard!
Great work. I really happy that I found your video because it helped me a lot in order to improve visual in many ways..
great Park, thanks for sharing your knowledge. I need your help, with the measures_5 delta py line negative and positive. In your case you use 3 base measures including the forecast one, in my data set, there would only be 2, kwh ac and kwh py, but when trying to replicate the delta py line neg and pos means, the bars do not appear, could you help me with the logic of the dax formula? without taking into account the measure of the fc forecast.
Relative values are kinda trick ones, but it's a Park's Seal of Quality job, thanks for sharing!
Thanks for the support 😁 at least I got it right this time
How to create the legend with the colors in the chart like Budget(greycolor) ActualMet(green color) which has different colorcode
How can I change the error value format? yo got for example 34k , If I want 34.000 ?
I needed this, thanks :)
I'm from BRazil... You Rock ;)
Thanks man, appreciate it!
how do you get the error labels to be formatted at thousands? I tried dynamic formatting on the pos error bar measure, but it does not work
So this isn't really possible right now as is, because the error bars unfortunately don't have the formatting option to change display units.
Honestly, if it was a make or break situation, I would use the same steps that I do to make the transparent bars for the relative % bars, and modify the values there.
You would need to use this:
Delta PY Vals = IF([_5 Delta PY] < 0,[_5 Delta PY Line]* 0.92 + [_5 Delta PY], [_5 Delta PY Line] + [_5 Delta PY])
@@PowerBIPark that is a good solution for now. Hopefully they add more customization to error labels in the future. Thank you!
can you order the info by percentage%
?
Yep, I have a pareto analysis video that shows how you would rank it :)
@@PowerBIPark Cool, I mean order they way we see the info, in your example the order is by month, Jan - feb - mar etc....but if I want to order by perfentage? From the highest to the lowest percentage?
That's what I mean, you just need to rank it
@@PowerBIPark thanks dude!
Is it possible to get these videos in Spanish?
Unfortunately I don't speak Spanish, but I appreciate the thought :)
Henstly this is crazy that someone need to almost hack BI in order to do this kind of visual. Way to complicated. I wish You did not skip through measures creation (with paste via dax query editor) as this is the important part i guess and the main idea.
I hear you, the amount of effort is a bit much, but there are other options like zebra bi or inforiver. Thanks for feedback, but most of the DAX I go into at length in the video so hopefully that helps