Forum Discussion

jcamilo1985's avatar
jcamilo1985
Helper III
5 years ago
Solved

ranking segmenter

Good morning experts
The following table represents sales by company, this is the dimensional table, the idea is to create a segmenter that allows me to choose, for example, 10%, 11%, 20%, 25% ... of the companies with the least amount of sales .

It occurred to me to create a ranking to classify companies by sales, leaving the ones with the lowest sales with ascending ranking and then from the segmenter choose a percentage of rows of the total, but I don't know how to perform the segmenter.
can someone please help me with this problem.

 

like this is only an idea of classification, if someone has a better way to do it I listen to suggestions.
In general, the idea is to identify which are the companies with the worst sales performance

 

any guidance will be appreciated

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi jcamilo1985 ,

     

    Based on your description, you have created the ranking calculated column.

    You can display the segmenter ranking by creating a what if parameter to use as a slicer and a measure to apply to the visual level filter.

     

    For more details,please refer to the sample .pbix

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies