[IBCS] New Column chart in Power BI - Feb 2024 Update

Published: 23 February 2024
on channel: Power BI Park

25,738

797

This is a tutorial on clustered bar charts in Power BI

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

🔥 PBI Core Visual Update: https://www.linkedin.com/pulse/additi...

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

::::::::::: 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'[DeltaPY] = IF(ISBLANK([FC]), [AC] - [PY], [FC] - [PY])
MEASURE 'IBCS data'[Max value] = IF(ISBLANK([FC]),
if([AC]□[PY], [AC], [PY]),
if([PY]□[FC], [PY], [FC]))
MEASURE 'IBCS data'[FC] = SUM('IBCS data'[2023 Predictions])
MEASURE 'IBCS data'[PY] = SUM('IBCS data'[2022])
MEASURE 'IBCS data'[AC] = SUM('IBCS data'[2023])
MEASURE 'IBCS data'[Red Max] = If([DeltaPY] ● 0, [Max value])
MEASURE 'IBCS data'[Green Max] = If([DeltaPY] □ 0, [Max value])
MEASURE 'IBCS data'[Delta Color] = IF( [DeltaPY] ● 0, "#ff0000","#008e96")
MEASURE 'IBCS data'[DeltaPY %] = DIVIDE ( [DeltaPY], [PY] )

Thanks for watching!

Watch video [IBCS] New Column chart in Power BI - Feb 2024 Update online without registration, duration hours minute second in high quality. This video was added by user Power BI Park 23 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 25,738 once and liked it 797 people.

3,872