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
Wow. I came across this video before, but could not absorb the knowledge. Now my work requirements have led me back to this one, and wow. How ingenious. You are the one champion Bas.
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.
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.
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!
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.
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!
Awesome Bas. You are a genius at coming up with solutions that are not obvious or not available natively in Power Bi. I feel like the Microsoft Power Bi team should consistently check in on your videos for ideas that they should then incorporate into Power Bi as standard functionality. Save us from creating so many additional measures just to accomplish these very useful tricks and tips.
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!
Just used the tricks. Awesome. I need to find a way to force the pages to use the same scale throughout. Different scales on different pages tend to skew one's visual perception.
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!
@@HowtoPowerBI Very well deserved! The content you make is invaluable, both the quality of the recording itself and the value of the ideas you come up with Keep up the good work!
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
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.
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
WOW! This video is full of amazing concepts. I'll be able to use pieces of this and the whole concept in my work right now! Thanks for always posting such great videos!
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.
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.
Hi Bas, this is really amazing. I found that same rank is returned for same values and because of this the no. of bars is sometimes not equal to the no. of items selected. It also returns blank on other pages. Could you help me on this? Thanks.
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
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.
💚 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] ) ) ) )
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.
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?
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 ?
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.
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
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?
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] & "°")
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?
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?
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)
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 .
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.
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
I just love this guys with all the out of box thinking to solve problems
😊
How did you even think of this? Unimaginable... Excellent mate...
The amount of creativity here is incredible
Awesome! Over 5-6 months without watching any video about PBI front-end and YT showed me this incredible opportunity!
Thanks!
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
You make the best Power BI tutorials… BY FAR!
Wow. I came across this video before, but could not absorb the knowledge. Now my work requirements have led me back to this one, and wow. How ingenious. You are the one champion Bas.
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.
that makes sense - good idea 😊
@@HowtoPowerBI I'm looking for this. If you can solve this, I'd really appreciate it.
this is impressive. Please keep these videos coming. Thanks to you, my boss is impressed by "my" work :D
Hello man, I'm new to the channel, but I've already become your fan, the content is of the highest quality.
Welcome aboard! 😁😊
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.
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!
Can't wait to try this. You always create awesome solutions!
😎👊 have fun
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.
yea that would nice! 😁 .. lets c if the dev team checks my vids
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!
Hi Bas!
here in Brazil, following your content.
Very rich content. Thanks for sharing 🚀
Great content. I respect your logical reasoning and creativity. You're making power BI report like a web designed interface. Kudos
Awesome Bas. You are a genius at coming up with solutions that are not obvious or not available natively in Power Bi. I feel like the Microsoft Power Bi team should consistently check in on your videos for ideas that they should then incorporate into Power Bi as standard functionality. Save us from creating so many additional measures just to accomplish these very useful tricks and tips.
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!
Bas the legend, as usual another masterpiece
It's 5 am here in Colombia... Bas video, time to learn!
Awesome 😎 it’s never a wrong time :)
Dude, you may are one of the top out there. Got so many insights and ideas from your videos! Thank you,really!
thx!
Learn everything I know about designing Power BI reports datatraining.io/powerbidesigntransformation
Brilliant! You always have solutions for tricky problems. Great work Bas!
Just used the tricks. Awesome.
I need to find a way to force the pages to use the same scale throughout. Different scales on different pages tend to skew one's visual perception.
Great solution, Bas!
I tried to implement it, but when a category filter is applied it breaks the visual.
Is there any work around?
This is amazing! I've never thought about providing a solution by manipulating a visual like this. Thank you for sharing this!
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!
I was waiting for this....let's goooooo
Lets goooo 🏃
mate, your videos starting to be even higher on my list than those from SQLBI :)
Bas !! You are awesome man. I have learned a many things from your channel. and yes seriously I loved it.
You are just amazing with power BI... 🤗
thank you 3x 😁
¡Gracias!
that's so nice - thanks for your support !!! 😊😁
@@HowtoPowerBI Very well deserved! The content you make is invaluable, both the quality of the recording itself and the value of the ideas you come up with
Keep up the good work!
That's amazing!
Does it work similarly with tables/matrixes? Or is it better to just use the paginated reports in that case?
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
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.
You are just amazing with power BI...
thank you 1x 😁
Brilliant. Very creative. Thank you for sharing. You often demonstrate outcomes that I didn't know were possible to achieve. Thanks again.
thank you Mark 😊
I love your work brother, I learn lot from your videos. Thanks a lot
love your content, always presenting fresh ideas to design reports, I appreciate it a lot, thank you.
thank you!! :D 😊
Fantastic video, thank you so much for this content. Amazing what you can do with a little bit of knowhow and trick!!!!
Glad you enjoyed it! 😊😎
You explain things very well. Thank you
really nice to hear that Thank you!!!
Everything you do gives me ideas for my dashboard, thanks
Happy to hear that!
this is just simply amazing, clever use of rank and slicers
😊 thx
Amazing!!! Ty for divide your knowledge with us!
your video arrived here in São Paulo, Brazil...TY
I was there 3 years ago! awesome , happy to hear my videos now make it all the way to São Paulo 😁
Soooooo good!!! So empowering. I feel like this 🧗♀️😁😁😁🙏🙏🙏🙏🙏
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
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
one of the most helpful video ,nice work keep up ,love to watch your videos whenever i have time.
You always come up with amazing Tricks
Just an awesome tip for a great UX. Great.
Waauw, your creativity keeps amazing me. Keep up the good work!
Thank you so much 😀 definitely will
WOW! This video is full of amazing concepts. I'll be able to use pieces of this and the whole concept in my work right now! Thanks for always posting such great videos!
awesome, great to hear that 😎
Stunning ... thanks for sharing this valuable things.....🎉
Thanks so much 😊
This is just mind blowing 🤯
Baaas… ur creativity has no limit! Paginate that!
Work of art! Keep it up. :)
Great idea, something I have been looking for. Another useful learning Bas
one more from the Master BlASter, thank you for sharing
Excellent workaround!
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.
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.
Hi Bas, this is really amazing.
I found that same rank is returned for same values and because of this the no. of bars is sometimes not equal to the no. of items selected. It also returns blank on other pages.
Could you help me on this? Thanks.
This is awesome! Thanks for sharing.
Excellent solution, Bas. As always!
thank you so much!!
Hello Bas, Hope you can take a look at this. How will the Ranx work with Field parameters?
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
Thanks a lot, really awesome approach and I'm going to use it
Excellent! Thank you!
Glad you enjoyed it!
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.
💚
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] ) ) )
)
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.
This is SUPER cool!
😎👊
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?
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 ?
I solved it 🎉
@@mohamedshiple1624 Do you mind sharing your solution? I am having the same issue.
Can you please share how you solved it? I am facing the same issue
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] )
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] )
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.
Excellent tutorial Bas. You are doing amazing job 👍
Glad you think so! 😁😊
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
I second this, I think this is more useful for Tablix and Matrix than any of the other visuals.
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?
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] & "°")
Excellent work, you have a big part in my power bi journey🎉
nice! happy i could help a bit on your pbi journey
Very useful trick thanks 👍
How do you handle the situation where items have same rank?
Our Boss is Back with new Dopamine
🏋️♂️💪😎😁
Beautiful, very useful feature and very well explained.
Glad it was helpful! thanks for watching! 😊
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?
@HowtoPowerBI, Can you make a videos on how to steps PowerBI like your workspace, Like you have vertical tool bar at the right !
You are great! Thank you so much! 😊
beautiful stuff
Brilliant! Round of applauses!
Awesome, perfect tutorial.
Thanks for an amazing content as always 🙂
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?
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)
You are awesome, could you please tell me how to sort columns in matrix table ?
Thanks 😊 here you go EVERYTHING YOU need to know about SORTING in POWER BI
ua-cam.com/video/T6p5xy35UPE/v-deo.html
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😊
got a lot of dax vids on this channel. if you like a more structured way maybe check out my learning path
S-Class instructor.
🏎️ 🏎️🏎️😎😁 thx
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 .
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.
Amazing content as usual. Do you have a video showing A-Z complete project with all the latest features + connect to database ?
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
Que bien, lo volvere a ver
double thanks for watch it twice 😁😎
You are awesome man!! Where do you get such ideas, seems like piwer bi is a fun game for you😅
This is sooooo GREAT!!! F****G GREAT!!!!
😎👊
How did you align the bar chart perfectly for this ?