[IBCS] New Column chart in Power BI - Feb 2024 Update
Вставка
- Опубліковано 22 лют 2024
- 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! - Наука та технологія
Great video! Please do more IBCS tutorials as they become available in the native visuals. They are highly appreciated
Thanks, I'm thinking of showing the variance in a line with its own errors, but we'll see how the week looks 😁
Great video bro, I really appreciate if you continue showing this kind of topics about how to incorporate IBCS to the visualization
Great tutorial thank you very much!
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!
Very useful insights. Thanks a lot
Like a good Power BI report, your videos are always clear and concise. Thank you!
Glad you like them!
great, thank you for sharing
Your video is too good and helpful 👏
Great stuff!
Great video. Thanks
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.
👋😊
Super awesome !!! Thank You..
Thanks for the feedback 😁
Awesome thank you for the video.
Fantastic
Thanks for sharing. If the multiline label option is available, we can show both: absolute and relative values. Nice job Park!
It's a valid point, I think you won't be disappointed to see me use multiline values in the next video 😁
Fantastic video... Injae is a star⭐
Nice Injae, I hadn't realised you could set a different label for a column (when you show the variance for the Max Value)
Thanks Wyn! There's a couple different ways to do this apparently, but I think this is the easiest approach 😁
Thanks for the Great Video. A better alternative to some third party visuals.
Glad you liked it!
very good video thank you
Amazing
This was very interesting!
nice
more! more! 👏👏👏
check my most recent videos that go a lot into depth with IBCS and native visuals :)
great video! how did you get the white legend symbol for past year to show a border instead of white?
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)
@@PowerBIPark thank you so much!
@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 ?
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 :)
@@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
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.
Thanks! This is a tiny dataset to show the visuals so it's not really relevant here, but I appreciate the comment
Thanks for such a great video . It would be great if you could share this Sample PIBIX file where you have implemented this ?
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 😁
Hi Injae,
How are you making dissapear the MaxValue from the legend?
I love your content man!! you are the best
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 😁
Never mind, I figured out. just renaming the measure by spacebar character :)
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.
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
Thanks a lot! I have had to update and restart for it to show! Thanks a million for following up! Much appreciated:)
Hey I'm glad you got it to work :)@@irienoma
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.
Did you make sure the data headers are properly set? Looks like that could be the issue
Great video again - is there a way to see variance of $ and % together?
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 😁
@@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
@@mohammedjaveed8643 absolutely, you just need to use "values" and "details". I do show this in my other videos:
ua-cam.com/video/00Q6o0tddd0/v-deo.htmlsi=YaE4iUAW8TckruBJ&t=514
@@PowerBIPark Perfect - thank you !!
how did you hide the "max value" in the legend at the end?
Replace the value name with a space! 😅
@@PowerBIPark thanks! Next question, how do you then create black border around the Past Year circle in legend?
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😁
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 😢
I really recommend looking for Reid Haven's, he has a video that uses line charts to show it 😁
I don`t see the error bars section in Format Visual. Is there a way to enable it?
It might be you have a previous version of power bi, make sure you have 2024 February version
Had to restart my system and now I see it. Thanks for your reply@@PowerBIPark
Silly sort of question: are these features available in the horizontal clustered bar chart?
Sorry I have no idea what the cluster4med chart is
@PowerBIPark apologies for the typos--I am inquiring about the horizontal clustered bar chart--the horizontal version of the bar chart depicted here.
I have a video on the clustered bar chart in the channel 😊
Everything worked fine until i started switching to previous years all my red FC bars won't disappear... Anyone else with this problem?
How about horizontal bar chart
Check out my latest videos, I have a tutorial already 😁
Thats nice, but tbh I have never worked on an projects where BU would say "Lets go with IBCS styled visuals"
I hear you, but it's the business' job to know what they want, it's our job to advise them