[IBCS] Advanced Power BI Tutorial - Native Column Chart

Published: 27 February 2024
on channel: Power BI Park

11,958

378

Get a 3 for 1 deal on Charts in Power BI

::::::::::: Links :::::::::::::::

🔥 IBCS style Matrix Tutorial: • NATIVE Power BI Table - Advanced Tuto...

🔥 IBCS Template: https://www.ibcs.com/resource/multi-t...

🔥 PBI Core Visual Update: https://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 ::::::::::::

DEFINE
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.3
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.92 + [_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

Watch video [IBCS] Advanced Power BI Tutorial - Native Column Chart online without registration, duration hours minute second in high quality. This video was added by user Power BI Park 27 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11,958 once and liked it 378 people.

133,850

2.6K