Sir, I have learned a lot from you, and I am very grateful that you provide such valuable knowledge to learners like us. Today's video is also very excellent.✨
Very helpful. I want to hear your take on this project I'm working on, I have to show 3 measures (Revenue, Profit and Profit %) and there are 2 main categories, Product Type and Client Type, the thing is under each main category there should be different data. If Product Type is selected it should show the products that belong to that type but if Client Type is selected just show the clients that belong to that type (Right now I'm using a matrix visual). Right now I'm using bookmarks thanks to your other video, but I wonder if it is possible to do something like that using field parameters.
It definitely sounds like from your description that Parameters would work. But I think bookmarks are a good option as well since you are showing multiple measures at the same time it sounds like for a dimension.
Great video. Just out of curiosity., and this is with respect to the category/subcategory parameter- say you have 8 categories and 30+ subcategories, and showing it as is on the report will make it look clumsy, you then want to show a filtered version using TOP N filter on the visual but based on user-selection, that seem a bit tricky to implement. Care to share insight on how you would approach solving that?
@@manlikeMrA correct, I would opt for a top 10 list for those larger dimensions or use a different visual such as a matrix if you need to show all. It can be done in a few different ways. I'll write this down and maybe create another video to spin off this one showing top 10 options.
@@manlikeMrA The code below would work in my tutorial example to only show top 10 for subcategories when selected, but show all for category. You apply it to the visual as a hidden visual filter and filter it to "1". Top10SubcategoryFilterOnly = VAR SelectedProduct = SELECTEDVALUE('_Product Par.'[_Product Par. Order]) -- Field Parameter VAR SelectedInsight = SELECTEDVALUE('_Insights Par.'[_Insights Par. Order]) -- Insight Parameter VAR RankDims = SWITCH( TRUE(), // SubCategory SelectedProduct = 1 && SelectedInsight = 0, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [Units Sold], , DESC), SelectedProduct = 1 && SelectedInsight = 1, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [Gross Sales], , DESC), SelectedProduct = 1 && SelectedInsight = 2, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [Net Profit], , DESC), SelectedProduct = 1 && SelectedInsight = 3, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [COGs], , DESC) ) RETURN IF( SelectedProduct = 1 && RankDims
@@ahmedshalaby9343 make sure you have the most updated power bi, you have selected the tile slicer, you have a parameter inside it, and you have single selection and force selection enabled.
Hello! I typically don't focus on data modeling on this channel or my courses. I may create a beginner course one day that does show this, but not sure. That being said there are a lot of youtube videos on data modeling you could try.
No, the completed source file for this is included in my Premium Course "14 Days to Mastering Power BI UX/UI Design". The link is here -->courses.nextlevelreports.com/14-days-mastering-ux-ui-design-website-path This course is on my platform. I do have a separate Udemy course, which is also included in my Premium course, and on the nextlevelreports.com platform.
Sir your videos are really helpful to my job, Can you please put full end to end power BI dashboard with updated functions and also please put separate videos for paginated report,power app, power automate all three are more important and urgent requirement for my project please help me ❤❤❤ ASAP 🙏
I learned a dozen things from this video. Great work here!
Glad this video was helpful! 👍
Sir, I have learned a lot from you, and I am very grateful that you provide such valuable knowledge to learners like us. Today's video is also very excellent.✨
I'm glad these videos have helped you! That's why I do them 👍
Thank you for such wonderful tutorial video. This is super helpful.
Wonderful video like always 🙏. Thank you!!
Thanks!
Glad this video was helpful to you! 👍
Very good!
Very helpful. I want to hear your take on this project I'm working on, I have to show 3 measures (Revenue, Profit and Profit %) and there are 2 main categories, Product Type and Client Type, the thing is under each main category there should be different data. If Product Type is selected it should show the products that belong to that type but if Client Type is selected just show the clients that belong to that type (Right now I'm using a matrix visual).
Right now I'm using bookmarks thanks to your other video, but I wonder if it is possible to do something like that using field parameters.
It definitely sounds like from your description that Parameters would work. But I think bookmarks are a good option as well since you are showing multiple measures at the same time it sounds like for a dimension.
Amazing video with details.
That is not my stuff, but i really enjoyed watching.
Do you help with developing a project ?
Appreciate that! 👍
Any non- video questions can be sent to Gary@nextlevelreports.com
Thank you
Greate ☺️🎉
Great video.
Just out of curiosity., and this is with respect to the category/subcategory parameter- say you have 8 categories and 30+ subcategories, and showing it as is on the report will make it look clumsy, you then want to show a filtered version using TOP N filter on the visual but based on user-selection, that seem a bit tricky to implement. Care to share insight on how you would approach solving that?
@@manlikeMrA correct, I would opt for a top 10 list for those larger dimensions or use a different visual such as a matrix if you need to show all. It can be done in a few different ways. I'll write this down and maybe create another video to spin off this one showing top 10 options.
@nextlevelpowerbireports super! I'll appreciate that.
Thanks for all the effort 💜
@@manlikeMrA The code below would work in my tutorial example to only show top 10 for subcategories when selected, but show all for category. You apply it to the visual as a hidden visual filter and filter it to "1".
Top10SubcategoryFilterOnly =
VAR SelectedProduct = SELECTEDVALUE('_Product Par.'[_Product Par. Order]) -- Field Parameter
VAR SelectedInsight = SELECTEDVALUE('_Insights Par.'[_Insights Par. Order]) -- Insight Parameter
VAR RankDims =
SWITCH(
TRUE(),
// SubCategory
SelectedProduct = 1 && SelectedInsight = 0, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [Units Sold], , DESC),
SelectedProduct = 1 && SelectedInsight = 1, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [Gross Sales], , DESC),
SelectedProduct = 1 && SelectedInsight = 2, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [Net Profit], , DESC),
SelectedProduct = 1 && SelectedInsight = 3, RANKX(ALLSELECTED(DIM_Product[Subcategory]), [COGs], , DESC)
)
RETURN
IF(
SelectedProduct = 1 && RankDims
@@nextlevelpowerbireports You're an angel. Love
i cannot find selection icon in the new slicer ?
@@ahmedshalaby9343 make sure you have the most updated power bi, you have selected the tile slicer, you have a parameter inside it, and you have single selection and force selection enabled.
Hi sir how to create datamodel with power bi restapis will you explain how to do it..thanks in advance
Hello! I typically don't focus on data modeling on this channel or my courses. I may create a beginner course one day that does show this, but not sure. That being said there are a lot of youtube videos on data modeling you could try.
@nextlevelpowerbireports thanks for the reply sir but no one suggest with rest apis data
Is this course on Udemy sir?
No, the completed source file for this is included in my Premium Course "14 Days to Mastering Power BI UX/UI Design". The link is here -->courses.nextlevelreports.com/14-days-mastering-ux-ui-design-website-path
This course is on my platform. I do have a separate Udemy course, which is also included in my Premium course, and on the nextlevelreports.com platform.
Sir your videos are really helpful to my job, Can you please put full end to end power BI dashboard with updated functions and also please put separate videos for paginated report,power app, power automate all three are more important and urgent requirement for my project please help me ❤❤❤ ASAP 🙏
I'm very happy to hear my tutorials have helped you in your job. And I appreciate the video suggestions. 👍
❤