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

[@jakob2746]

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

[@PowerBIPark]

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

[@patrickosorio7424]

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

[@santoshwaghmare4081]

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!

[@777tmack]

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

[@PowerBIPark]

Glad you like them!

[@fsanfo]

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

[@PowerBIPark]

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

[@Belhakor]

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. 👋😊

[@AccessAnalytic]

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]

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

[@syrophenikan]

Thank you! I quite like the build process and the showcasing of different features and how you can use them in combination to achieve situation-specific results.

[@PowerBIPark]

Glad you like it! That's the style I'm trying to incorporate into my videos :)

[@ΣυμεώνΠαπαδόπουλος-λ4ο]

Great tutorial thank you very much!

[@mcwahaab]

Very useful insights. Thanks a lot

[@mona12393]

Your video is too good and helpful 👏

[@abdelytics]

Fantastic video... Injae is a star⭐

[@JMRG2992]

is there a tutorial two create a double bar column stacked and clusterd bar ? I found others but not as clear as this one

[@brajakishoresutar3964]

Great video, but why am I not seeing the error bar option in my visual format

[@gokul3151]

Great video! good explanation.. I can't able to find the error bars please to help me out

[@rodneydieguez52]

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

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]

@@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

[@marie-pierd.2656]

Amazing tutorial thank you !!

[@surajraju5384]

What did you do to disappear max value in the legends ?

[@rafaeldias3010]

Great video! How could you end up excluding from the legend the 'Max value' measure and the circle around the white color at the end of the video?

[@rafaeldias3010]

Part of the awnser : To remove the measure 'Max value' from the legend we can name it only by a space!:)

[@excel-solutions4564]

Super awesome !!! Thank You..

[@PowerBIPark]

Thanks for the feedback 😁

[@DPaquette]

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]

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

[@jamesrosicky2912]

Great stuff!

[@aspirethrissur4016]

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

[@PowerBIPark]

Glad you liked it!

[@maxzr]

Great video. Thanks

[@SoukainaChakour]

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]

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

[@connerkoski2183]

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

[@PowerBIPark]

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]

@@PowerBIPark thank you so much!

[@unnikrishnansanthosh]

great, thank you for sharing

[@kamaur01]

Awesome thank you for the video.

[@jamescarpenter1893]

Silly sort of question: are these features available in the horizontal clustered bar chart?

[@PowerBIPark]

Sorry I have no idea what the cluster4med chart is

[@jamescarpenter1893]

@PowerBIPark apologies for the typos--I am inquiring about the horizontal clustered bar chart--the horizontal version of the bar chart depicted here.

[@PowerBIPark]

I have a video on the clustered bar chart in the channel 😊

[@andreyanpilov2593]

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]

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

[@irienoma]

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]

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]

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

[@PowerBIPark]

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

[@mythilysathish7725]

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

[@PowerBIPark]

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

[@mythilysathish7725]

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

[@mohammedjaveed8643]

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

[@PowerBIPark]

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]

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

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

[@mohammedjaveed8643]

@@PowerBIPark Perfect - thank you !!

[@jakob2746]

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

[@PowerBIPark]

Replace the value name with a space! 😅

[@jakob2746]

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

[@PowerBIPark]

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😁

[@kajalmiglani7345]

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

[@PowerBIPark]

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 😁

[@ductrung1312]

How about horizontal bar chart

[@PowerBIPark]

Check out my latest videos, I have a tutorial already 😁

[@ajaaskelainen]

This was very interesting!

[@cosladacity1]

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

[@PowerBIPark]

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]

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

[@muhammetmuslu4429]

very good video thank you

[@ashleytaaffe9423]

Fantastic

[@bjornopjemic]

Everything worked fine until i started switching to previous years all my red FC bars won't disappear... Anyone else with this problem?

[@shahzadkheros]

Amazing

[@besteberry]

more! more! 👏👏👏

[@PowerBIPark]

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

[@timestoryx]

nice

[@remek5758]

Thats nice, but tbh I have never worked on an projects where BU would say "Lets go with IBCS styled visuals"

[@PowerBIPark]

I hear you, but it's the business' job to know what they want, it's our job to advise them