[IBCS] Advanced Power BI Tutorial - Native Bar Chart (With PBIX)

Рет қаралды 8,389

4 ай бұрын

::::::::::: Links :::::::::::::::
🔥PBIX here: workout-wednesday.com/pbi-202...
🔥 IBCS style Matrix Tutorial: • NATIVE Power BI Table ...
🔥 IBCS Template: www.ibcs.com/resource/multi-t...
🔥 PBI Core Visual Update: www.linkedin.com/pulse/additi...
::::::::::: Data :::::::::::::::
Month Number , Month , 2022 , 2023 ,2023 Predictions
1 , January , 2825.00 , 7140.00 ,
2 , February , 5005.00 , 1614.00 ,
3 , March , 3612.00 , 14752.00 ,
4 , April , 2978.00 , 933.00 ,
5 , May , 8662.00 , 6343.00 ,
6 , June , 4750.00 , 8223.00 ,
7 , July , 4433.00 , 6953.00 ,
8 , August , 2062.00 , 9041.00 ,
9 , September , 9329.00 , 10992.00 ,
10 , October , 16243.00 , 9275.00 ,
11 , November , 4011.00 , , 9690.10
12 , December , 17885.00 , , 8483.35
:::::::::: Measures ::::::::::::
DEFINEDEFINE
MEASURE 'IBCS Data'[_5 Delta PY] = IF(ISBLANK([_1 FC]), [_1 AC] - [_1 PY], [_1 FC] - [_1 PY])
MEASURE 'IBCS Data'[_2 Max value] = IF(ISBLANK([_1 FC]),
if([_1 AC]□[_1 PY], [_1 AC], [_1 PY]),
if([_1 PY]□[_1 FC], [_1 PY], [_1 FC]))
MEASURE 'IBCS Data'[_1 FC] = SUM('IBCS Data'[2023 Predictions])
MEASURE 'IBCS Data'[_1 PY] = SUM('IBCS data'[2022])
MEASURE 'IBCS Data'[_1 AC] = SUM('IBCS data'[2023])
MEASURE 'IBCS Data'[_6 Delta PY %] = DIVIDE ( [_5 Delta PY], [_1 PY] )
MEASURE 'IBCS Data'[_5 Delta PY Line] = [_4 ACPY MAX] * 2.1
MEASURE 'IBCS Data'[_5 Delta PY Line Positive AC] = IF(ISBLANK([_1 FC]),IF([_5 Delta PY] □0, [_5 Delta PY Line] + [_5 Delta PY], blank()))
MEASURE 'IBCS Data'[_5 Delta PY Line 2] = [_5 Delta PY Line]
MEASURE 'IBCS Data'[_5 Delta PY Line Negative AC] = IF(ISBLANK([_1 FC]),
IF([_5 Delta PY] ●0, [_5 Delta PY Line] + [_5 Delta PY], blank())
)
MEASURE 'IBCS Data'[_6 Delta PY % Line] = [_4 ACPY MAX] * 3.8
MEASURE 'IBCS Data'[_6 Delta PY % Line 2] = [_6 Delta PY % Line]
MEASURE 'IBCS Data'[_6 Delta PY % Line Positive AC] = IF(ISBLANK([_1 FC]),
IF([_6 Delta PY %] □0, [_6 Delta PY % Line] + [_6 Delta PY %]*[_7 Percentage Bar Modifier], blank()))
MEASURE 'IBCS Data'[_6 Delta PY % Line Negative AC] = IF(ISBLANK([_1 FC]),IF([_6 Delta PY %] ● 0, [_6 Delta PY % Line] + [_6 Delta PY %]*[_7 Percentage Bar Modifier], blank()))
MEASURE 'IBCS Data'[_3 title color top] = IF(ISBLANK([_1 FC]),
if([_5 Delta PY] □ 0, "#000000", "#B3B3B3"),
if([_5 Delta PY] □ 0, "#118DFF", "#B3B3B3"))
MEASURE 'IBCS Data'[_3 title color bot] = IF(ISBLANK([_1 FC]),
if([_5 Delta PY] ● 0, "#000000", "#B3B3B3"),
if([_5 Delta PY] ● 0, "#118DFF", "#B3B3B3"))
MEASURE 'IBCS Data'[_6 Delta PY % Line FC] = IF(ISBLANK([_1 FC]),blank(), [_6 Delta PY % Line] + [_6 Delta PY %]*[_7 Percentage Bar Modifier])
MEASURE 'IBCS Data'[_5 Delta PY Line Negative FC] = IF(ISBLANK([_1 FC]),blank(),
IF([_5 Delta PY] ●0, [_5 Delta PY Line] + [_5 Delta PY])
)
MEASURE 'IBCS Data'[_5 Delta PY Line 3] = [_5 Delta PY Line]
MEASURE 'IBCS Data'[_6 Delta PY % Line 3] = [_6 Delta PY % Line]
MEASURE 'IBCS Data'[_7 Delta PY % Vals] = IF([_6 Delta PY %] ● 0,[_6 Delta PY % Line]* 0.94 + [_6 Delta PY %]*[_7 Percentage Bar Modifier], [_6 Delta PY % Line] + [_6 Delta PY %]*[_7 Percentage Bar Modifier])
MEASURE 'IBCS Data'[_5 Delta PY Line Postivie FC] = IF(ISBLANK([_1 FC]),blank(),
IF([_5 Delta PY] □0, [_5 Delta PY Line] + [_5 Delta PY])
)
MEASURE 'IBCS Data'[_7 Delta PY % label] = DIVIDE ( [_5 Delta PY], [_1 PY] )*100
MEASURE 'IBCS Data'[_4 ACPY MAX] = MAXX(ALLSELECTED('IBCS Data'), [_2 Max value])
MEASURE 'IBCS Data'[_4 Y Axis Max] = [_4 ACPY MAX] * 4.8
MEASURE 'IBCS Data'[_2 Min value] = IF(ISBLANK([_1 FC]),
if([_1 AC]●[_1 PY], [_1 AC], [_1 PY]),
if([_1 PY]●[_1 FC], [_1 PY], [_1 FC]))
MEASURE 'IBCS Data'[_7 Delta PY % label Color] = IF(ISBLANK([_1 FC]),
if([_5 Delta PY] □ 0, "#3C931A", "#D64550"), "#118DFF")
MEASURE 'IBCS Data'[_7 Percentage Bar Modifier] = DIVIDE( [_4 ACPY MAX], MAXX(ALLSELECTED('IBCS Data'), [_6 Delta PY %]))*0.7

Пікірлер: 21

@hernanaruj 3 ай бұрын

Dear Park, I recommend your post on Linkedin every time I can. You rock, you are very clear explaining. Thaks from Argentina

@PowerBIPark 3 ай бұрын

Thanks Hernan. I really hope my videos help you do better professionally 😊

@YB-iq7fc 3 ай бұрын

Great work. I really happy that I found your video because it helped me a lot in order to improve visual in many ways..

@rokiczaaa 3 ай бұрын

I needed this, thanks :)

@bottonline4544 3 ай бұрын

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 .

@PowerBIPark 3 ай бұрын

I've put the pbix in the description, maybe it will help ☺

@kunwang2279 4 ай бұрын

Awesome by using native chart. previously have to use SVG. and really like this series of creating charts following IBCS

@PowerBIPark 4 ай бұрын

Thanks man, I really hope it helps you and others 😁

@ArtfulData 3 ай бұрын

This would be amazing to enhance the Power BI dashboard!

@marquuezin 4 ай бұрын

I'm from BRazil... You Rock ;)

@PowerBIPark 4 ай бұрын

Thanks man, appreciate it!

@fsanfo 4 ай бұрын

Relative values are kinda trick ones, but it's a Park's Seal of Quality job, thanks for sharing!

@PowerBIPark 4 ай бұрын

Thanks for the support 😁 at least I got it right this time

@royarahmatian4541 Күн бұрын

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

@davidjosevarelagarcia7011 3 ай бұрын

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.

@connerkoski2183 3 ай бұрын

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

@PowerBIPark 3 ай бұрын

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])

@connerkoski2183 3 ай бұрын

@@PowerBIPark that is a good solution for now. Hopefully they add more customization to error labels in the future. Thank you!

@Wzxxx 4 ай бұрын

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.

@PowerBIPark 4 ай бұрын

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