[IBCS] New Column chart in Power BI

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

Рет қаралды 20,403

4 ай бұрын

This is a tutorial on clustered bar charts in Power BI
=================================
🔥 IBCS Template: www.ibcs.com/resource/multi-t...
🔥 PBI Core Visual Update: www.linkedin.com/pulse/additi...
🔥 IBCS style Matrix Tutorial: • NATIVE Power BI Table ...
=================================
::::::::::: 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!

Пікірлер: 72

@jakob2746 4 ай бұрын

Great video! Please do more IBCS tutorials as they become available in the native visuals. They are highly appreciated

@PowerBIPark 4 ай бұрын

Thanks, I'm thinking of showing the variance in a line with its own errors, but we'll see how the week looks 😁

@user-li7mq5hp9g 4 ай бұрын

Great tutorial thank you very much!

@mcwahaab 4 ай бұрын

Very useful insights. Thanks a lot

@santoshwaghmare4081 4 ай бұрын

Great job on the video! Your clear explanation and hands-on approach make it easy to follow along. Can't wait to try out IBCS-styled charts in my reports!

@patrickosorio7424 4 ай бұрын

Great video bro, I really appreciate if you continue showing this kind of topics about how to incorporate IBCS to the visualization

@unnikrishnansanthosh 4 ай бұрын

great, thank you for sharing

@mona12393 4 ай бұрын

Your video is too good and helpful 👏

@777tmack 4 ай бұрын

Like a good Power BI report, your videos are always clear and concise. Thank you!

@PowerBIPark 4 ай бұрын

Glad you like them!

@maxzr 4 ай бұрын

Great video. Thanks

@excel-solutions4564 4 ай бұрын

Super awesome !!! Thank You..

@PowerBIPark 4 ай бұрын

Thanks for the feedback 😁

@jamesrosicky2912 4 ай бұрын

Great stuff!

@kamaur01 4 ай бұрын

Awesome thank you for the video.

@abdelraoufyessoufou3190 4 ай бұрын

Fantastic video... Injae is a star⭐

@ashleytaaffe9423 4 ай бұрын

Fantastic

@fsanfo 4 ай бұрын

Thanks for sharing. If the multiline label option is available, we can show both: absolute and relative values. Nice job Park!

@PowerBIPark 4 ай бұрын

It's a valid point, I think you won't be disappointed to see me use multiline values in the next video 😁

@Belhakor 22 күн бұрын

Great Video, As it's been a while since the video was released I doubt that my comment will have much impact but if it can be of use to anyone, By putting "Max value" in the second position of the Y Axis we can reduce the Space between categories to 25% for a better distinction between categories and deltas. 👋😊

@ajaaskelainen 2 ай бұрын

This was very interesting!

@muhammetmuslu4429 3 ай бұрын

very good video thank you

@AccessAnalytic 4 ай бұрын

Nice Injae, I hadn't realised you could set a different label for a column (when you show the variance for the Max Value)

@PowerBIPark 4 ай бұрын

Thanks Wyn! There's a couple different ways to do this apparently, but I think this is the easiest approach 😁

@shahzadkheros Ай бұрын

Amazing

@timestoryx 4 ай бұрын

nice

@aspirethrissur4016 Ай бұрын

Thanks for the Great Video. A better alternative to some third party visuals.

@PowerBIPark Ай бұрын

Glad you liked it!

@besteberry 3 ай бұрын

more! more! 👏👏👏

@PowerBIPark 3 ай бұрын

check my most recent videos that go a lot into depth with IBCS and native visuals :)

@andreyanpilov2593 15 күн бұрын

Good video, thank you. I think you can optimize your model if you make addition transformation on PQ side. I would suggest to unpivot other columns than MonthNumber and Month.

@PowerBIPark 13 күн бұрын

Thanks! This is a tiny dataset to show the visuals so it's not really relevant here, but I appreciate the comment

@rodneydieguez52 4 ай бұрын

@PowerBIPark thanks for sharing this awesome chart !!! I hope you can share a lot more of this... 😊 I did follow the steps, but I have a question: in my chart, if did select just one MONTH in the segmentation visual, the last [max value], December, keeps on display alone (in red)... I note you use another kind of data for the segmentation, it's a Calendar table ?

@PowerBIPark 4 ай бұрын

Hi Rodney, so I don't do anything additional here in the tutorial, but in one of the versions you see (the first and last example), there is a calendar table used to connect to the data :) PErsonally I don't see this issue, when I use a month slicer, it acts for me as expected. Hope that helps somehow :)

@rodneydieguez52 4 ай бұрын

@@PowerBIPark I couldn't test yet using a calendar table, I'm in trouble now. I promise to test it and share it here if it works. Cheers

@connerkoski2183 4 ай бұрын

great video! how did you get the white legend symbol for past year to show a border instead of white?

@PowerBIPark 4 ай бұрын

Thanks! So basically if you use emojis, you can use a white circle, or if you use a geometric shape, it can also be a circle 😁 I do show it in my other video but don't have a link rn (from phone)

@connerkoski2183 4 ай бұрын

@@PowerBIPark thank you so much!

@SoukainaChakour 3 ай бұрын

So great video 👏. Could you please do another example where we would have to compare more than 2 series on each month (example : AC vs PY vs Budget) ?I’m stuck on that 😢

@PowerBIPark 3 ай бұрын

I really recommend looking for Reid Haven's, he has a video that uses line charts to show it 😁

@cosladacity1 4 ай бұрын

Hi Injae, How are you making dissapear the MaxValue from the legend? I love your content man!! you are the best

@PowerBIPark 4 ай бұрын

Hey, so it's quite easy- just make the name of the measure to be a space bar, so like " ". Then you can also make the icon of the py show up by using the windows key + semicolon, and select geometric symbols to get an empty circle 😁

@cosladacity1 4 ай бұрын

Never mind, I figured out. just renaming the measure by spacebar character :)

@DPaquette 3 ай бұрын

The new measures do not show up only an entry with "DeltaPY" with exclamation > error The value for FC can not be determined. Either the column does not exist or there is no current row for this column.

@PowerBIPark 3 ай бұрын

Did you make sure the data headers are properly set? Looks like that could be the issue

@irienoma 4 ай бұрын

Hey, can anyone help me understand how to enable this "Update model: Add new measure"? I don't have it when I navigate to the DAX Query View.

@PowerBIPark 4 ай бұрын

Hey are you still struggling with this? I've heard some people had to update their desktop and restart the whole pc, but hopefully it shows up for you

@irienoma 4 ай бұрын

Thanks a lot! I have had to update and restart for it to show! Thanks a million for following up! Much appreciated:)

@PowerBIPark 4 ай бұрын

Hey I'm glad you got it to work :)@@irienoma

@mythilysathish7725 4 ай бұрын

I don`t see the error bars section in Format Visual. Is there a way to enable it?

@PowerBIPark 4 ай бұрын

It might be you have a previous version of power bi, make sure you have 2024 February version

@mythilysathish7725 4 ай бұрын

Had to restart my system and now I see it. Thanks for your reply@@PowerBIPark

@jakob2746 4 ай бұрын

how did you hide the "max value" in the legend at the end?

@PowerBIPark 4 ай бұрын

Replace the value name with a space! 😅

@jakob2746 4 ай бұрын

@@PowerBIPark thanks! Next question, how do you then create black border around the Past Year circle in legend?

@PowerBIPark 4 ай бұрын

If you're on PC, hit windows and semicolon, it should open up emojis and special characters. Use the empty circle in the name of the measure😁

@mohammedjaveed8643 4 ай бұрын

Great video again - is there a way to see variance of $ and % together?

@PowerBIPark 4 ай бұрын

Hey, thanks! I think if you want to see them together the best thing is to check my latest video where I show you how to do just that 😁

@mohammedjaveed8643 4 ай бұрын

@@PowerBIPark Sorry if i was not clear on my question, is there a way to see data label of var $ and % together? Example: $115k, +50% at the top of each bar

@PowerBIPark 4 ай бұрын

@@mohammedjaveed8643 absolutely, you just need to use "values" and "details". I do show this in my other videos: kzfaq.info/get/bejne/ZpaBadJh2crIlGQ.htmlsi=YaE4iUAW8TckruBJ&t=514

@mohammedjaveed8643 4 ай бұрын

@@PowerBIPark Perfect - thank you !!

@kajalmiglani7345 3 ай бұрын

Thanks for such a great video . It would be great if you could share this Sample PIBIX file where you have implemented this ?

@PowerBIPark 3 ай бұрын

Hi, I had an idea to make a of my pbix for Patreon supporters - but I still haven't got around to it. Most of the code I have freely available for you anyway 😁