Glad it was helpful! Hope you will like other videos too Power BI Concepts 180+ Videos: th-cam.com/video/cAqjakPjbMU/w-d-xo.html Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Mastering Microsoft Fabric 50+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Hey, thanks for this! I have a question -- how do you make this interact with your main table, i.e., if I select bad, the table beside it will also be filtered
@justapasserby69420 , Please check, these video has very similar options Dynamic segmentation -Measure to Dimension conversion: th-cam.com/video/gzY40NWJpWQ/w-d-xo.html Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: th-cam.com/video/EyL7KMw877Q/w-d-xo.html Power BI ABC Analysis using Window function, Dynamic Segmentation: th-cam.com/video/A8mQND2xSR4/w-d-xo.html
Watch additional video on the same: Dynamic segmentation -Measure to Dimension conversion: th-cam.com/video/gzY40NWJpWQ/w-d-xo.html Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: th-cam.com/video/W4EF1f_k6iY/w-d-xo.html
You are welcome! Hope you will like the similar videos Dynamic Segmentation, Bucketing or Binning: th-cam.com/video/CuczXPj0N-k/w-d-xo.html Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: th-cam.com/video/EyL7KMw877Q/w-d-xo.html Power BI ABC Analysis using Window function, Dynamic Segmentation: th-cam.com/video/A8mQND2xSR4/w-d-xo.html And these series Complete Power BI in one Video 11 hours: th-cam.com/video/cN8AO3_vmlY/w-d-xo.html Mastering Power BI 230+ videos: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html Power BI Concepts 160+ Videos: th-cam.com/video/cAqjakPjbMU/w-d-xo.html Mastering Microsoft Fabric 40+ Videos: th-cam.com/video/p-v0I5S-ybs/w-d-xo.html Ultimate Power BI Guide: 50 Essential Interview Questions & 10 Advanced Use Case Tutorials 2024: th-cam.com/video/Wfr1Wh5SxwM/w-d-xo.html
@@AmitChandak Sorry i may have explained badly what i wanted, i saw the video and it didn't explain what i was asking. What i'm trying to do would be to have the bucket table with the counts but instead a matrix with a sublevel that let me see the name of the customers that belong to the bucket. Something like this : Bad 1692 Custome 100 Customer 1003 Good 1804 Customer10
@@AmitChandak i don't need it to be fully dynamic, here is whaat I need exactly, I have a table with three collumns, employee ID, Employe name, employe Age what I need is to divide the ages into four categories ( 0 - 25 / 26 - 45 ... ) this is just an example, but what i exactly need is to calculate the median of ages ( its done ) , and categorize the ages into four ( 25 % of the median ) into a seperate table of course ( that table will update dynamically when the ages change and when the report is refreshed ) I hope its clear
Perfect!..thanks a lot!
Glad it was helpful!
Hope you will like other videos too
Power BI Concepts 180+ Videos:
th-cam.com/video/cAqjakPjbMU/w-d-xo.html
Mastering Power BI 230+ videos:
th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Mastering Microsoft Fabric 50+ Videos:
th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Hey, thanks for this! I have a question -- how do you make this interact with your main table, i.e., if I select bad, the table beside it will also be filtered
@justapasserby69420 , Please check, these video has very similar options
Dynamic segmentation -Measure to Dimension conversion: th-cam.com/video/gzY40NWJpWQ/w-d-xo.html
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: th-cam.com/video/EyL7KMw877Q/w-d-xo.html
Power BI ABC Analysis using Window function, Dynamic Segmentation: th-cam.com/video/A8mQND2xSR4/w-d-xo.html
Watch additional video on the same: Dynamic segmentation -Measure to Dimension conversion: th-cam.com/video/gzY40NWJpWQ/w-d-xo.html
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: th-cam.com/video/W4EF1f_k6iY/w-d-xo.html
Power BI Tutorial Series for Beginners: th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Power BI for Advance User: th-cam.com/video/59PUFuuCrbY/w-d-xo.html
Oh my god!! Dude, you saved me. Thanks a lot!
You are welcome!
Hope you will like the similar videos
Dynamic Segmentation, Bucketing or Binning: th-cam.com/video/CuczXPj0N-k/w-d-xo.html
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: th-cam.com/video/EyL7KMw877Q/w-d-xo.html
Power BI ABC Analysis using Window function, Dynamic Segmentation: th-cam.com/video/A8mQND2xSR4/w-d-xo.html
And these series
Complete Power BI in one Video 11 hours:
th-cam.com/video/cN8AO3_vmlY/w-d-xo.html
Mastering Power BI 230+ videos:
th-cam.com/video/wvsAzTqSDVg/w-d-xo.html
Power BI Concepts 160+ Videos:
th-cam.com/video/cAqjakPjbMU/w-d-xo.html
Mastering Microsoft Fabric 40+ Videos:
th-cam.com/video/p-v0I5S-ybs/w-d-xo.html
Ultimate Power BI Guide: 50 Essential Interview Questions & 10 Advanced Use Case Tutorials 2024:
th-cam.com/video/Wfr1Wh5SxwM/w-d-xo.html
Hi, what if you want to use a matrix to drop down a level and see which customer belong to which bucket?
Refer this example: Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: th-cam.com/video/EyL7KMw877Q/w-d-xo.html
@@AmitChandak Sorry i may have explained badly what i wanted, i saw the video and it didn't explain what i was asking. What i'm trying to do would be to have the bucket table with the counts but instead a matrix with a sublevel that let me see the name of the customers that belong to the bucket. Something like this :
Bad 1692
Custome 100
Customer 1003
Good 1804
Customer10
Explained so well!!! Wonderful!!!!😀
Glad it was helpful!
How can we use a dynamic margin range? I have a total sales table and I want to know what is net profit when 42% margin is used or 50%
Thanks sir .
Your solutions always are out of the box and optimized🙏
Glad to hear that
For Customer Retention Watch: th-cam.com/video/Q1vPWmfI25o/w-d-xo.html
- Customer Churn Analysis
- Customer Retention/Cohort Analysis
- Customer Clustering Analysis
- Winner Brand by Geography Analysis
- Data Table Creation
Watch Power BI Tutorial Series for Beginners:: th-cam.com/play/PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb.html
Watch New Series Dax vs SQL - th-cam.com/play/PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj.html
Nice video with a good explanation on each step.
Thank you Sir!
So nice of you
very useful
Keep watching
Also Check - Dynamic segmentation -Measure to Dimension conversion: th-cam.com/video/gzY40NWJpWQ/w-d-xo.html
what i wan't is that the start limit and end limit fo each category must be dynamic according to data
Table Range(Column) can not be dynamic. So need an example of what you need
@@AmitChandak i don't need it to be fully dynamic, here is whaat I need exactly,
I have a table with three collumns, employee ID, Employe name, employe Age
what I need is to divide the ages into four categories ( 0 - 25 / 26 - 45 ... ) this is just an example, but what i exactly need is to calculate the median of ages ( its done ) , and categorize the ages into four ( 25 % of the median ) into a seperate table of course ( that table will update dynamically when the ages change and when the report is refreshed ) I hope its clear
community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626