cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jwight Frequent Visitor
Frequent Visitor

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

 

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?

4 REPLIES 4
Community Support Team
Community Support Team

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

Hi @jwight ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
jwight Frequent Visitor
Frequent Visitor

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

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.

Community Support Team
Community Support Team

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

Hi @jwight ,

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.

67.gif

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
jwight Frequent Visitor
Frequent Visitor

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

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.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 44 members 1,083 guests
Please welcome our newest community members: