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

Поделиться
HTML-код
  • Опубликовано: 27 дек 2024

Комментарии • 81

  • @jakob2746
    @jakob2746 10 месяцев назад +10

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад +4

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

  • @patrickosorio7424
    @patrickosorio7424 10 месяцев назад +3

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

  • @fsanfo
    @fsanfo 10 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад

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

  • @santoshwaghmare4081
    @santoshwaghmare4081 10 месяцев назад

    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
    @777tmack 10 месяцев назад

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

  • @Belhakor
    @Belhakor 6 месяцев назад +1

    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
    @AccessAnalytic 10 месяцев назад

    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
      @PowerBIPark  10 месяцев назад

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

  • @syrophenikan
    @syrophenikan 3 месяца назад

    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
      @PowerBIPark  3 месяца назад

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

  • @ΣυμεώνΠαπαδόπουλος-λ4ο
    @ΣυμεώνΠαπαδόπουλος-λ4ο 10 месяцев назад

    Great tutorial thank you very much!

  • @abdelytics
    @abdelytics 10 месяцев назад

    Fantastic video... Injae is a star⭐

  • @mcwahaab
    @mcwahaab 10 месяцев назад

    Very useful insights. Thanks a lot

  • @mona12393
    @mona12393 10 месяцев назад

    Your video is too good and helpful 👏

  • @connerkoski2183
    @connerkoski2183 9 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  9 месяцев назад +1

      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
      @connerkoski2183 9 месяцев назад

      @@PowerBIPark thank you so much!

  • @marie-pierd.2656
    @marie-pierd.2656 2 месяца назад

    Amazing tutorial thank you !!

  • @excel-solutions4564
    @excel-solutions4564 10 месяцев назад

    Super awesome !!! Thank You..

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад

      Thanks for the feedback 😁

  • @JMRG2992
    @JMRG2992 2 месяца назад

    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
    @brajakishoresutar3964 4 месяца назад

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

  • @unnikrishnansanthosh
    @unnikrishnansanthosh 10 месяцев назад

    great, thank you for sharing

  • @jamesrosicky2912
    @jamesrosicky2912 10 месяцев назад

    Great stuff!

  • @rafaeldias3010
    @rafaeldias3010 2 месяца назад

    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
      @rafaeldias3010 2 месяца назад

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

  • @surajraju5384
    @surajraju5384 2 месяца назад

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

  • @maxzr
    @maxzr 10 месяцев назад

    Great video. Thanks

  • @rodneydieguez52
    @rodneydieguez52 10 месяцев назад +1

    @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
      @PowerBIPark  10 месяцев назад

      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
      @rodneydieguez52 10 месяцев назад

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

  • @gokul3151
    @gokul3151 5 месяцев назад

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

  • @SoukainaChakour
    @SoukainaChakour 9 месяцев назад

    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
      @PowerBIPark  9 месяцев назад

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

  • @mohammedjaveed8643
    @mohammedjaveed8643 10 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад

      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
      @mohammedjaveed8643 9 месяцев назад

      @@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
      @PowerBIPark  9 месяцев назад

      @@mohammedjaveed8643 absolutely, you just need to use "values" and "details". I do show this in my other videos:
      ruclips.net/video/00Q6o0tddd0/видео.htmlsi=YaE4iUAW8TckruBJ&t=514

    • @mohammedjaveed8643
      @mohammedjaveed8643 9 месяцев назад

      @@PowerBIPark Perfect - thank you !!

  • @DPaquette
    @DPaquette 9 месяцев назад

    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
      @PowerBIPark  9 месяцев назад

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

  • @ashleytaaffe9423
    @ashleytaaffe9423 10 месяцев назад

    Fantastic

  • @jamescarpenter1893
    @jamescarpenter1893 8 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  8 месяцев назад

      Sorry I have no idea what the cluster4med chart is

    • @jamescarpenter1893
      @jamescarpenter1893 8 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  8 месяцев назад

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

  • @kamaur01
    @kamaur01 9 месяцев назад

    Awesome thank you for the video.

  • @andreyanpilov2593
    @andreyanpilov2593 6 месяцев назад

    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
      @PowerBIPark  6 месяцев назад

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

  • @mythilysathish7725
    @mythilysathish7725 10 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад

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

    • @mythilysathish7725
      @mythilysathish7725 10 месяцев назад

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

  • @jakob2746
    @jakob2746 10 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад +2

      Replace the value name with a space! 😅

    • @jakob2746
      @jakob2746 10 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад +2

      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😁

  • @besteberry
    @besteberry 9 месяцев назад

    more! more! 👏👏👏

    • @PowerBIPark
      @PowerBIPark  9 месяцев назад

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

  • @ductrung1312
    @ductrung1312 9 месяцев назад

    How about horizontal bar chart

    • @PowerBIPark
      @PowerBIPark  9 месяцев назад

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

  • @ajaaskelainen
    @ajaaskelainen 8 месяцев назад

    This was very interesting!

  • @irienoma
    @irienoma 10 месяцев назад

    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
      @PowerBIPark  9 месяцев назад

      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
      @irienoma 9 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  9 месяцев назад

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

  • @cosladacity1
    @cosladacity1 10 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад

      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
      @cosladacity1 10 месяцев назад

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

  • @muhammetmuslu4429
    @muhammetmuslu4429 9 месяцев назад

    very good video thank you

  • @shahzadkheros
    @shahzadkheros 7 месяцев назад

    Amazing

  • @kajalmiglani7345
    @kajalmiglani7345 9 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  8 месяцев назад

      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 😁

  • @aspirethrissur4016
    @aspirethrissur4016 6 месяцев назад

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

  • @timestoryx
    @timestoryx 10 месяцев назад

    nice

  • @bjornopjemic
    @bjornopjemic 9 месяцев назад

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

  • @remek5758
    @remek5758 10 месяцев назад

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

    • @PowerBIPark
      @PowerBIPark  10 месяцев назад

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