Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |