Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @Anonymous
You can use EnterData and calculated column to achieve your goal.
I build two tables to have a test.
Rev Table:
Slicer Table:
Add a calculated column in Slicer Table.
Virtual Bracket Granted =
VAR _MINK =
DIVIDE ( Slicer[Min], 1000 ) & "" & "k€"
VAR _MAXK =
DIVIDE ( Slicer[Max], 1000 ) & "" & "k€"
RETURN
IF (
Slicer[Max] = BLANK (),
COMBINEVALUES ( "-", _MINK, BLANK () ),
COMBINEVALUES ( "-", _MINK, _MAXK )
)
Result:
Then build a measure in Rev Table.
Measure =
VAR _Select =
SELECTEDVALUE ( Slicer[Virtual Bracket Granted] )
VAR _Min =
CALCULATE ( SUM ( Slicer[Min] ), Slicer[Virtual Bracket Granted] = _Select )
VAR _Max =
CALCULATE ( SUM ( Slicer[Max] ), Slicer[Virtual Bracket Granted] = _Select )
VAR _Revenue =
SUM ( 'Rev'[Revenue] )
RETURN
IF (
_Max = BLANK ()
&& _Revenue >= _Min,
_Revenue,
IF ( _Revenue >= _Min && _Revenue < _Max, _Revenue, BLANK () )
)
Result:
You can download the pbix file from this link: How to create Bucket in PowberBI
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
Hi @Anonymous
You can use EnterData and calculated column to achieve your goal.
I build two tables to have a test.
Rev Table:
Slicer Table:
Add a calculated column in Slicer Table.
Virtual Bracket Granted =
VAR _MINK =
DIVIDE ( Slicer[Min], 1000 ) & "" & "k€"
VAR _MAXK =
DIVIDE ( Slicer[Max], 1000 ) & "" & "k€"
RETURN
IF (
Slicer[Max] = BLANK (),
COMBINEVALUES ( "-", _MINK, BLANK () ),
COMBINEVALUES ( "-", _MINK, _MAXK )
)
Result:
Then build a measure in Rev Table.
Measure =
VAR _Select =
SELECTEDVALUE ( Slicer[Virtual Bracket Granted] )
VAR _Min =
CALCULATE ( SUM ( Slicer[Min] ), Slicer[Virtual Bracket Granted] = _Select )
VAR _Max =
CALCULATE ( SUM ( Slicer[Max] ), Slicer[Virtual Bracket Granted] = _Select )
VAR _Revenue =
SUM ( 'Rev'[Revenue] )
RETURN
IF (
_Max = BLANK ()
&& _Revenue >= _Min,
_Revenue,
IF ( _Revenue >= _Min && _Revenue < _Max, _Revenue, BLANK () )
)
Result:
You can download the pbix file from this link: How to create Bucket in PowberBI
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , you have made bucket as a standalone table with limits and create a measure to use this table
refer
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bins
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-in-power-bi/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
@Anonymous
You create a table using the following option: ENTER DATA - You can paste from Excel as well
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |