UX Revolution with Visual Level PAGINATION in Power BI

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ต.ค. 2024

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

  • @DilipSaini888
    @DilipSaini888 ปีที่แล้ว +40

    I just love this guys with all the out of box thinking to solve problems

  • @slowchrno
    @slowchrno ปีที่แล้ว +8

    Another amazing videos Bas! Thank you! Do you have any plans on making videos about the mobile formatting? My bosses love opening the reports through their cell but I find the mobile options to make reports so lacking. A video about mobile design would be great!

  • @charliemather3368
    @charliemather3368 ปีที่แล้ว +14

    Beautiful solution!! One concern is that the maximum value of the axis changes based on the filter context. I would recommend creating a measure for the maximum axis value based on ALL dealers so as you filter the lower ranked dealers would continually decrease in bar length.

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

      that makes sense - good idea 😊

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

      @@HowtoPowerBI I'm looking for this. If you can solve this, I'd really appreciate it.

  • @vickimce93
    @vickimce93 หลายเดือนก่อน +1

    I have found this so helpful. But I am wondering would anyone be able to help me as when I put in on a line graph I can't get it to work but it works perfect for a bar chart?

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

    Learn everything I know about designing Power BI reports datatraining.io/powerbidesigntransformation

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

    Great solution, Bas!
    I tried to implement it, but when a category filter is applied it breaks the visual.
    Is there any work around?

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

    How did you even think of this? Unimaginable... Excellent mate...

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

    Another one of those things that should simply be supported natively, but great work in crafting a slick solution! I'll have to find a project to make us of this technique.

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

      yea that would nice! 😁 .. lets c if the dev team checks my vids

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

    You are just amazing with power BI... 🤗

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

    this is impressive. Please keep these videos coming. Thanks to you, my boss is impressed by "my" work :D

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

    Great content. I respect your logical reasoning and creativity. You're making power BI report like a web designed interface. Kudos

  • @Khan-mc3gi
    @Khan-mc3gi ปีที่แล้ว +1

    Can u tell me how i learn this dax language which u using himself there is any link of website i want to become master in dax as u😊

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

      got a lot of dax vids on this channel. if you like a more structured way maybe check out my learning path

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

    I just got a job that required power BI skills, maybe 80% all of my work will be using this bi tools, just subscribed and looking forward to watch all of your vid sir lol

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

    Great video! Can this method be used to extract data from pbi. Let’s say the that user is extracting is more than 150k they can see at the bottom number of pages and click on it to get complete data. I think the only issue will row counting.

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

    thank you so much for this amazing and creative video.
    i would like to share a version of Item Filter measure that gives the possibility to select many pages :
    Item Filter =
    VAR _Number_of_Items = [# Items Value]
    VAR _ItemRank = [Item Rank]
    VAR SelectedPages=
    ADDCOLUMNS(
    DISTINCT('# Pages'[# Pages]),
    "IsSelected",
    VAR _Page=[# Pages]
    return
    CONVERT(
    _ItemRank > (_Page - 1) * _Number_of_Items
    && _ItemRank

  • @GabrielCosta-wn1wt
    @GabrielCosta-wn1wt 8 หลายเดือนก่อน +1

    That's amazing!
    Does it work similarly with tables/matrixes? Or is it better to just use the paginated reports in that case?

    • @HowtoPowerBI
      @HowtoPowerBI  8 หลายเดือนก่อน +1

      yes that would work in the same way. Like you say, you need to check what would be a better solution in your case .. either the paginated reports visual or like in the vid

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

      I'm finding that if you keep just the Dealer and the Sales columns, it works fine. Start adding more columns, as you would with any tablix, and things start getting weird.

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

    I have tried same with Matrix visual, somehow Item filter and Page filter not working as expected. When I select different number in item filter, Pages filter not changing according. It always shows maximum no of pages

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

    U r genius, bless u for sharing ur knowledge with us, i had a Q- can we make slider vertical?
    plz do a video if we can thanx

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

      thanks for watching! Not completely sure what you have in mind. You can take a slicer, switch to tiles and adjust the with so that the items appear below each other vertically

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

    I noticed when converting the graph to a tablix and attempting to make pagination happen with multiple columns, very unexpected behaviours start to occur. Just the two columns (Dealer and Sales) does seem to work with a tablix visual. This would be elite if we could offer pagination for a standard tablix with say, 15 columns.
    Additionally, going back to this particular visual, if you had a Dealer with no sales (lets say they were closed) then it can trigger a blank record which could in turn trigger a pagination link with nothing on that page. Would have to add a condition to check for Sales > 0 somewhere.

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

    Hi Bas!
    here in Brazil, following your content.
    Very rich content. Thanks for sharing 🚀

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

    Hi Bas! Thank you for an amazing video- I never thought this could be possible!
    I tried replicating this with the funnel chart but it didnt work. Any guidance is appreciated :)

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

    Does PAGINATION bring some performance improvements, or would the whole data be load once by opening the report site?

  • @b.malikovich
    @b.malikovich ปีที่แล้ว

    Guys please help, Why I don't have in formatting "Custom lables"? Should I update my pbi?

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

    Am i right in thinking this is better on performance as its not loading thousands of records and just what is filtered. One issue i have found in my live model 14k rows this doesnt work as the filter measure=1 just makes my chart do nothing like it cant compute it so after 2 mins i cancel but On a small dataset its perfect but i would have thought it would be super speedy :(.

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

    @HowtoPowerBI, Can you make a videos on how to steps PowerBI like your workspace, Like you have vertical tool bar at the right !

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

    Luckily i have subscribed you.. its very interesting. Instead of static # number items.. can we dynamically update based on the y axis distinct count . And show a lable that #number of items available to enter in that show items fields. Its my thought.

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

    Cool! Great video, just one quation: how do you perform this when you want to add the LY Sales for each category? If I add this now it will get filtered out.

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

    Had some issue that on the visual it will show 1 like below the bar after applying filter, but wasnt sure what to do as I was trying to do it more than two bars like if for example car Dealer -> Sales & Net Profit. Wanted so it could filter between those two
    Or I wanted to compare the sales and filter by month and do the ranking

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

    What version of PBI Desktiop is that?

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

      that was recorded with the august 2023 version ( on object interaction turned on under preview options )

  • @aleksandrask7383
    @aleksandrask7383 3 หลายเดือนก่อน +1

    Why would anyone prefer clicking pages instead of just scroll is beyond my comprehension..

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

      lol

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

      Scrolling thousands of records is a poor user experience. Pagination is absolutely a solid solution where appropriate.

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

      ​@@MichaelDoig
      "Scrolling thousands of records is a poor user experience" - Tell that to MS Excel team with worksheets :)
      And imagine Excel worksheet with PAGES instead of scrolling down for the data..
      "where appropriate" is the key :)
      if there are 2-5 pages - scroll is better.
      if there are 100s of pages - then filter should be the best solution

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

      @@aleksandrask7383 I'd rather the Google search results model (pagination) over scrolling (and potential memory issues) with lots of scrolling.

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

    what if i dont have Total Labels option? is there a chance to obtain similar solution? my company doesnt provide update of PowerBi i thnk that's the problem

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 5 หลายเดือนก่อน

    How can we create drill through for individual data points of Matrix visual in power BI?

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

    The automatically created measure for # Pages value. What is the DAX code for that?

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

    Hello man, I'm new to the channel, but I've already become your fan, the content is of the highest quality.

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

    Bro put a video for exact step by step Process for power bi analyst work in real world project

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

    Hello Bas, Hope you can take a look at this. How will the Ranx work with Field parameters?

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

    Total labels are not showing in format pane while creating a bar chart
    even though I provided 2 series in the bar chart, please help me with how to enable it .

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

    Bas the legend, as usual another masterpiece

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

    October Update of Power Bi doesn't let you add custom labels

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

    Why am i getting the dense rank type of output if i use Rankx your 4 th and 5th rank looks correct

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

    If you do INT( logical check) you get the same result as IF( logical check, 1, 0). INT( logical check ) converts TRUE = 1, FALSE = 0

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

      true, I think however for most viewers writing it with IF is easier to follow

  • @priyaarya5882
    @priyaarya5882 11 หลายเดือนก่อน +1

    Hi Bas :)
    I really liked the idea. Do you have something in mind which can be used to implement the pagination in Power BI Tables rather than using custom visual

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

      I second this, I think this is more useful for Tablix and Matrix than any of the other visuals.

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

    Fantastic video, thank you so much for this content. Amazing what you can do with a little bit of knowhow and trick!!!!

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

      Glad you enjoyed it! 😊😎

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

    You make the best Power BI tutorials… BY FAR!

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

    Applause! Wish I knew about this a few years ago!
    Anyhow, I have a project that I tried this with using the Power KPI Matrix 3.1.1 visual and it works with this pagination configuration except now the matrix is not formatted correctly (showing percents on kpi rows formatted as numbers) in the online service only. I try to fix but when I click on edit it goes back to normal. However, the incorrect formatting shows up again in the next session. Anyone else come across this bug? The original report with its many tabs does not have this problem but I absolutely love the pagination and want to keep it.

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

      Alright found out that the Power Matrix 3.1.1 has limited capacity to save formatting changes per measure so the page filter comes up with unexpected results 😢 vs copying/pasting with multiple page tabs that I originally had it. I hope to use this trick in another visual when the opportunity arises.

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

    I have a problem where, when I applied a filter for the page number because I have many duplicates in my items, if I set it to show 20 items per page, due to the duplicates of ranking, it shows more than 20. Consequently, I end up with empty pages because the result of dividing the total number of items by the items per page is very large, as I mentioned earlier, due to the duplicates of ranking the items .. do you have a soultion for that please ?

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

      I solved it 🎉

    • @JustinMead-OU
      @JustinMead-OU ปีที่แล้ว +1

      @@mohamedshiple1624 Do you mind sharing your solution? I am having the same issue.

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

      Can you please share how you solved it? I am facing the same issue

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

      Measure =
      VAR XTABE =
      CALCULATETABLE (
      ADDCOLUMNS (
      ALL ( 'New-participants'[School_Name] ),
      "Participant", [Total no of students participate]
      ),
      'New-participants'[status] = "result computed"
      )
      VAR xx =
      ADDCOLUMNS (
      SUMMARIZE ( XTABE, [Participant] ),
      "C", COUNTROWS ( FILTER ( XTABE, [Participant] = EARLIER ( [Participant] ) ) )
      )
      VAR CountRows_ForUNIQ_NO_OFSChools =
      COUNTROWS ( xx )
      VAR _itemCount = [# Items Value]
      VAR _No_of_pages =
      ROUNDUP ( DIVIDE ( CountRows_ForUNIQ_NO_OFSChools, _itemCount ), 0 )
      VAR Result =
      IF ( SELECTEDVALUE ( '# Pages'[# Pages] )

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

      Measure =
      VAR XTABE =
      CALCULATETABLE (
      ADDCOLUMNS (
      ALL ( 'New-participants'[School_Name] ),
      "Participant", [Total no of students participate]
      ),
      'New-participants'[status] = "result computed"
      )
      VAR xx =
      ADDCOLUMNS (
      SUMMARIZE ( XTABE, [Participant] ),
      "C", COUNTROWS ( FILTER ( XTABE, [Participant] = EARLIER ( [Participant] ) ) )
      )
      VAR CountRows_ForUNIQ_NO_OFSChools =
      COUNTROWS ( xx )
      VAR _itemCount = [# Items Value]
      VAR _No_of_pages =
      ROUNDUP ( DIVIDE ( CountRows_ForUNIQ_NO_OFSChools, _itemCount ), 0 )
      VAR Result =
      IF ( SELECTEDVALUE ( '# Pages'[# Pages] )

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

    It's 5 am here in Colombia... Bas video, time to learn!

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

      Awesome 😎 it’s never a wrong time :)

  • @JoaoCarlos-qg5cn
    @JoaoCarlos-qg5cn 10 หลายเดือนก่อน +1

    The amount of creativity here is incredible

  • @JoaoCarlos-qg5cn
    @JoaoCarlos-qg5cn 10 หลายเดือนก่อน

    This tutorial is fantastic; I've successfully applied it to my dashboard. I'd like to share a useful tip from my experience.
    In my scenario, since my visual included filters, using the ALL() function caused it to overlook the #1 rank. To address this, I switched to using ALLSELECTED():
    Item Rank =
    RANKX(
    ALLSELECTED(
    Sales[ShopName]),
    [Total de Produções UnB]
    )
    However, this led to a new issue: without using ALL, every page displayed the same ranking. To resolve this, I modified the Item Rank Label as follows:
    Item Rank Label =
    IF(
    '# Pages'[# Pages Values] = 1,
    [Item Rank] & "°",
    ( '# Pages'[# Pages Values] - 1) * '# Items'[# Items Values] + [Item Rank] & "°")

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

    How does that big brain fit in that head of yours? Great video.

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

    I have an issue with comparing integer to text from the customer name?

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

    Brilliant! Round of applauses!

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

    💚
    Proposed improvements:
    - calculate a rank with RANKX but filter out zeros and blanks.
    rankMeasure =
    VAR temp =
    SUM ( Table1[Value] )
    RETURN
    IF (
    temp = 0,
    BLANK (),
    RANKX ( ALL ( Table1[Name] ), CALCULATE ( SUM ( Table1[Value] ) ) )
    )

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

    love your content, always presenting fresh ideas to design reports, I appreciate it a lot, thank you.

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

    Does this work with slicers and filter pane? 😂

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

    Can't wait to try this. You always create awesome solutions!

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

    Baaas… ur creativity has no limit! Paginate that!

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

    What happens if the rank is same for two bars then it will cause error

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

    Hey, man! Thanks for the tutorial, real nice! Just a question: when I hade another date slicer filtering, and I go for a previous date, the pages doesn't automatically adapts. I guess I'll need another measure (like for the number of itens), but this time for my date slicer.

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

    You explain things very well. Thank you

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

      really nice to hear that Thank you!!!

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

    You are just amazing with power BI... 🤗

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

    I have a chart that have 119 items, and this definitely stepped up the visual, thank you so much! Looking forward to the upcoming transformation training in a couple of weeks!

  • @JustinMead-OU
    @JustinMead-OU ปีที่แล้ว

    @HowToPowerBI - I am really enjoying and learning from your videos; please keep up the great work. I have a similar problem as another commenter, I have several "items" that have the same ranking. This is causing my pages to not always stick to the specified item limit per page and I also have pages that are blank. Is there a solution for this issue?

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

    it is impossible to keep up with you. Great, while I was making a matrix table recently, I thought why there is no such feature in Power. Thank you very much.

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

    Excellent video bas, i have used several of your videos in my projects and they have really been helpful. One question from me is what's the advantage of using this over actual paginated reports visual?

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

    Great video and explanation!
    My question is:
    Can I use these same 2 parameters to do pagination for my other graphs on the dashboard? Or every time I do pagination I will have to create 2 different parameters (page and item) per graph?

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

    Soooooo good!!! So empowering. I feel like this 🧗‍♀️😁😁😁🙏🙏🙏🙏🙏

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

    Excellent workaround!

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

    You are great! Thank you so much! 😊

  • @snehasamuel7426
    @snehasamuel7426 20 วันที่ผ่านมา

    This is just mind blowing 🤯

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

    You are just amazing with power BI...

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

    this looks amazing... my only concern is that as we move to higher pages the top bar will always define the max lenght of the bar, meaning that we lose context of that item against the whole. is there a way to fix the X avis range across pages so that as we move along the index the higher pages will have smaller bars?

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

      yes possible. I think I've done that in the file for the video "Get MORE out of Your BAR CHARTS " (you can find the download link from the description)

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

    can we do this with matrix visual

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

    I'm pretty sure that, even the people who developed Power BI software, don't know how to do this. It requires alot of deep understanding and experience.

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

    Everything you do gives me ideas for my dashboard, thanks

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

      Happy to hear that!

  • @EricsonLima-s3l
    @EricsonLima-s3l ปีที่แล้ว

    Hi Bas!
    Look where your teachings have reached - all the way to Brazil. Immense gratitude for your guidance. When you decide to visit this side of the world, please let me know so we can enjoy some coconut water or, even better, a cold beer with a tropical flavor. May God continue to bless you always!

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

    Amazing content as usual. Do you have a video showing A-Z complete project with all the latest features + connect to database ?

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

    Thank you so much for this video so helpful. I am trying to use it where I have a legend that breaks down my sales into locations but I can't get it to work if I have the legend of locations in. Do you have any advice of how I could resolve this issue

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

    Bas !! You are awesome man. I have learned a many things from your channel. and yes seriously I loved it.

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

    Great idea, something I have been looking for. Another useful learning Bas

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

    Very useful trick thanks 👍
    How do you handle the situation where items have same rank?

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

    Your tutorial brings me next level, and also have self-confidence. That I had been trying about this solution for past two months ago because our clients want to get selected items range on specified page. Now I will give the solution to my clients and also feel good. I am so impressing on you, and you get the brain from God. Thank you and waiting for more helpful tips and tricks about power bi.

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

    mate, your videos starting to be even higher on my list than those from SQLBI :)

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

    Awesome! Over 5-6 months without watching any video about PBI front-end and YT showed me this incredible opportunity!
    Thanks!

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

    You are awesome man!! Where do you get such ideas, seems like piwer bi is a fun game for you😅

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

    Brilliant! You always have solutions for tricky problems. Great work Bas!

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

    How did you align the bar chart perfectly for this ?

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

    one of the most helpful video ,nice work keep up ,love to watch your videos whenever i have time.

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

    You are awesome, could you please tell me how to sort columns in matrix table ?

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

      Thanks 😊 here you go EVERYTHING YOU need to know about SORTING in POWER BI
      th-cam.com/video/T6p5xy35UPE/w-d-xo.html

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

    This is amazing! I've never thought about providing a solution by manipulating a visual like this. Thank you for sharing this!

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

    I love your work brother, I learn lot from your videos. Thanks a lot

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

    You always come up with amazing Tricks

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

    Amazing!!! Ty for divide your knowledge with us!
    your video arrived here in São Paulo, Brazil...TY

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

      I was there 3 years ago! awesome , happy to hear my videos now make it all the way to São Paulo 😁

  • @AfrozAlam-ig9ec
    @AfrozAlam-ig9ec ปีที่แล้ว

    Just one quick question. Considering 50 million records in the dataset how about the performance of the dashboard? With all this customization/calculations we are doing to acheive the pagination with such high volume of data how to still keep the performance of the dashboard intanct? (load time should be within 10-15 secs)
    PS - This is an amazing tutorial. I loved your work :) Thank you for sharing!!

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

      Going even further - it would be nice how this performs with direct query tables... if this will be an improvement or decrease performance.

  • @stuartjohnson-haigh6210
    @stuartjohnson-haigh6210 ปีที่แล้ว

    Great video, thank you. Could you do a video expanding on this to give the user the option to how they want to sort ie by sales value or by total items or by supplier etc please

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

    Thanks a lot, really awesome approach and I'm going to use it

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

    you are th boss man

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

    Thanks Bas for all the resources you've shared, another great illustration of what you can do with Power BI. Your videos help me to improve every time!

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

    one more from the Master BlASter, thank you for sharing

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

    I was waiting for this....let's goooooo