[HELP] CREATING A SELECTOR BASED ON RANGE OF VALUES FROM A MEASURE

[Anonymous]

OK here is my issue. I have a measure that measures change of pace for products. so something might be selling great in December but not so great in August (think winter coats!). so we will say that there is a 99% drop off in winter coats between Dec and Aug. what I'm looking to do is create select able ranges to see what products are moving up and down.

so give me products that have dropped by 25%, 50, 75%, 100% and the reverse products that have risen by those values during measured time period. i want that as a slicer.

any ideas?

[v-shex-msft]

Hi @Anonymous ,

Nope, measure is calculated based on row contents, it need at least one category field to expand corresponded calculation result. You can't use it in a slicer.

In my opinion. I'd like to recommend you refer to following link to use measure as visual level filter.

Applying a measure filter in Power BI

Regards,

Xiaoxin Sheng

[Anonymous]

I'm sorry but you are not correct. You can create slicers based on measures. you create a disconnected table and use that as your selector.

[v-shex-msft]

Hi @Anonymous ,

I'm not so sure what you mean.

Based on my test, I still not able to use a measure on value fields and visual level filter of a slicer.

If you mean SSAS measure fields with import mode, power bi will break it's data type and recognize them as columns with fixed values.

Regards,

Xiaoxin Sheng

[Anonymous]

The solution to my issues was  to created the corect bins for my disconnected slicer to use.

@v-shex-msft  the basic idea is this  https://www.youtube.com/watch?v=gEeiqsm7BaY

 you create a table using enter data. you add the ranges for your bins, label and key. then you write your measure.

PERCENTAGE SORT =
COUNTROWS (
    FILTER (
        PARTS,
        AND (
            [month over month CHANGE] > MIN ( RANGES[MIN] ),
            [month over month CHANGE] <= MAX ( RANGES[MAX] )
        )
    )
 

 Your filter then can be used for the ranges (or whatever value) you place in the table you created to use your slicer.