SMALL MULTIPLES in Power BI | All you need to know!

แชร์
ฝัง
  • เผยแพร่เมื่อ 9 ม.ค. 2025

ความคิดเห็น • 28

  • @HowtoPowerBI
    @HowtoPowerBI  4 ปีที่แล้ว +6

    How do you like small multiples so far?

  • @CJ-jc8tn
    @CJ-jc8tn 3 ปีที่แล้ว +2

    Wasn't aware of this new visual. Thanks for sharing Bas! Another great video where I know more today than I did yesterday due to your videos.

    • @HowtoPowerBI
      @HowtoPowerBI  3 ปีที่แล้ว

      awesome, I hope you find some nice ways of using this new visual!

  • @miguelcaldas746
    @miguelcaldas746 3 ปีที่แล้ว +2

    Excellent explanation! Congrats!!!

  • @sashiakarlsen6817
    @sashiakarlsen6817 2 ปีที่แล้ว +1

    Do you know if it is possible to add a constant line based on a measure there for each small multiples creates a unique constant line??

  • @giacomoluddeni6512
    @giacomoluddeni6512 3 ปีที่แล้ว +1

    Great video thanks! Is there a way to add a calculated average line for every graph?

  • @andytran4435
    @andytran4435 ปีที่แล้ว

    Thank you for the video. I also would like to know if I use a clustered column chart, how the DAX will be?

  • @indradutta4136
    @indradutta4136 2 ปีที่แล้ว +1

    Kudos to you for explaining it so well. Your name should be BOSS!! instead of BAS. Great work.

    • @HowtoPowerBI
      @HowtoPowerBI  2 ปีที่แล้ว

      Hahahah hillarious :) thx for the nice words

  • @Divya25293
    @Divya25293 หลายเดือนก่อน

    Hey! Is there a way to avoid showing categories in X axis that have blank measure value?

  • @MrChan0458
    @MrChan0458 3 ปีที่แล้ว +1

    @How to Power Bi, how does the conditional colour formatting translate to the line charts? currently it only seems to work in bar charts.

    • @HowtoPowerBI
      @HowtoPowerBI  3 ปีที่แล้ว

      I think you can apply conditional formatting to the markers, but not to the line itself yet

  • @berrymind-o2j
    @berrymind-o2j 2 ปีที่แล้ว

    I can't find the button to enable small multiples in Options > preview and features on the new Bower BI Desktop is there any alternatives ? Thank you

  • @kristibenedict1178
    @kristibenedict1178 4 ปีที่แล้ว +1

    Are you able to use tool tips with small multiples? I have 14 different branch locations (Atlanta, Cleveland, Detroit and so on) that I want to use a tool tip with to populate the Top 5 Lost Cases by Item for each specific small multiple branch I hover over but I cant seem to make that work. It just groups all of the branches together instead of doing the specific one I'm hovering over.

    • @HowtoPowerBI
      @HowtoPowerBI  4 ปีที่แล้ว +1

      Hi Kristi, thanks for your question. Yes, you can use custom tooltips and it should filter on the different branch locations. I just tried it on the example file in the video. Not sure why it is not working for you. If you like I can have a quick look, just send me a sample file (bas.dohmen@datatraining.io)

  • @bpowell68
    @bpowell68 ปีที่แล้ว

    Hi, Bas! Your content has elevated my work in so many ways! I have a question.
    Is it possible to add URL link for each small multiple? For instance, I'm breaking out a cost over time line by small multiples based on the "project" field. I want to be able to have a clickable link on each small multiple chart that the user can click on. This link will take them to a separate application landing page for that specific project. We're able to do this just fine in a table/matrix, but we would love to be able to embed a link icon for each small multiple chart for each project. I hope you have a solution! Thanks so much for everything you do!

  • @pranaysharma8694
    @pranaysharma8694 2 ปีที่แล้ว

    is it possible to add the x-axis for each section?

  • @kennethstephani692
    @kennethstephani692 ปีที่แล้ว

    Great video!

  • @cathrerinezetadrones3169
    @cathrerinezetadrones3169 ปีที่แล้ว

    Why cant I apply conditional formatting on small multiples in this Version: 2.116.966.0 64-bit (April 2023) I've gotta be missing something

  • @RichardOliver
    @RichardOliver 4 ปีที่แล้ว

    Thanks, Bas. I expect these will also improve performance of reports i.e. 1 small multiples visual vs x number of individual visuals.

    • @HowtoPowerBI
      @HowtoPowerBI  4 ปีที่แล้ว

      thats right Richard! Power BI would send 1 query for the small multiples visual instead of one for each visual you would otherwise have to create

  • @richardlock89
    @richardlock89 4 ปีที่แล้ว +1

    Thanks Bas!

  • @ahlimanabdullayev8497
    @ahlimanabdullayev8497 7 หลายเดือนก่อน

    perfect, thanks

  • @andreibulatov2395
    @andreibulatov2395 4 ปีที่แล้ว

    Thanks!

  • @1yyymmmddd
    @1yyymmmddd 3 ปีที่แล้ว +1

    I really do not understand why Microsoft is creating all this stuff that can be easily accomplished with existing Power BI means.

    • @HowtoPowerBI
      @HowtoPowerBI  3 ปีที่แล้ว

      How did you do it before? I would have created multiple small visuals, but that would take longer to load and to create.

    • @1yyymmmddd
      @1yyymmmddd 3 ปีที่แล้ว

      @@HowtoPowerBI Yes, but it is possible to do. There are plenty of things that you can do in Qlick View, but not in PBI :)