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.
Hello, sorry, the value of ∆PY% is dumb for me. I count the values by hand, but this cannot be calculated at all. Now the month of January will be 133, not 153. Similarly, the following months
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])
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
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 ☺
Great work. I really happy that I found your video because it helped me a lot in order to improve visual in many ways..
I needed this, thanks :)
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!
I'm from BRazil... You Rock ;)
Thanks man, appreciate it!
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
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.
Hello, sorry, the value of ∆PY% is dumb for me. I count the values by hand, but this cannot be calculated at all. Now the month of January will be 133, not 153. Similarly, the following months
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!
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