Creating Profit Buckets by Number of Customers

[Akhil_1411]

Hi,

Can anyon help me with the below requirement.

I am trying to acheive the below Profit bucket table(power BI) in the form of graph attached is the screenshot and the power BI file ( Buckets are created on measures)      Power Bi File:- https://we.tl/t-HzZ46RQiNrRequirement GraphPower BI Table

Thanks,

Akhil.

[amitchandak · Accepted solution]

@Akhil_1411 , profit is a measure? of so refer to dynamic segmentation or binning

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

if is a column

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...

[harshnathani]

Hi @Akhil_1411 ,

Guess this is a duplicate post

Please read this. Very important 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Check the link for your earlier post.

https://community.powerbi.com/t5/Desktop/AllExcept-column-with-slicer-value/m-p/1231394#M545975

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi Akhil,

Hope you've come right.

Just a tip from my side - make sure to capture all the data in your profit buckets. For example, do not start at 0% as some products are unprofitable (i.e. negative). I would suggest sorting your data to see the minimums and maximums - use this info to set buckets and capture all data. If the raw data set is large then you might prefer to use the MIN and MAX functions rather to determine this.

Kind regards

[amitchandak · Accepted solution]

@Akhil_1411 , profit is a measure? of so refer to dynamic segmentation or binning

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

if is a column

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...

[Akhil_1411]

Hi @amitchandak ,

Thanks for sharing.

I tried dynamic segmentation it works. But, when i click on dynamic segmentation visual the other visuals are not cross filtered. How to acheive that?

Power BI File:- https://we.tl/t-ZSxsaBIH9H

Regards,

Akhil.

[Fowmy · Accepted solution]

@Akhil_1411 

As there is no relationship between the  Bucket Table and the Order (it's a disconnected Table), you can try below Profit Measure in visuals where you need the impact when filtering from Segment Buckets

DSB Profit = CALCULATE(
    SUM(Orders[Profit]),
    FILTER(
        VALUES(Orders[Customer ID]),
        [Dynamic Segmentation]<>BLANK()
    )
)

If you are satisfied with my answer, please mark it as a solution so others can easily find it.

Don't forget to give KUDOS to replies that help answer your questions

Subscribe to ExcelFort: Learn Power BI, Power Query and Excel

[Akhil_1411]

Hi @Fowmy ,

Noted. But, i have in my report four different bucket sized visuals  and 6 different measures. If i start using the below logic the measures will be overloaded right is there any other way i can link this?

Thanks.

[Fowmy]

@Akhil_1411 

Measures only get calculated when they are evaluated, it will overload, You can create Mesures for each metric as I showed you where you need to filter by Buckets.

This will not burden your model.

If you are satisfied with my answer, please mark it as a solution so others can easily find it.

Don't forget to give KUDOS  to replies that help answer your questions

Subscribe to ExcelFort: Learn Power BI, Power Query and Excel