Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

[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?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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