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.
I would like to have the functionality of a column-based slicer using a measure column as my slicing feature.
What I would like my slicer by measure to produce.
What I get is a semi sort of the select item that disappears if reverse sorted.
Slicing method based on: DAX Fridays #204: Slice by the results of a measure
https://www.youtube.com/watch?v=xO9Caya9Qxw
PBIX attached link: https://drive.google.com/file/d/129-Wk-Dhfh2H6FqQgb8okyz4Vf8zn2SY/view?usp=sharing
All data anonymized.
You probably know that slicers only work with columns (native or calculated), not with measures. Maybe explain your goal a bit more.
I understand that typically one slices with a column. In this case, I have constucted a measure which calculates a category. I would like to use this measure category to filter my table results. If the measure is placed within the filter panel and then a specific category entry is applied it filters as expected. I want this type of functionality usable in some type of selectable button which shows only the selected results. There are solutions referenced which can do this based on a measure number range. I would like to have this same functionality based on a text based category. I have this partially working within the example pbix file. I am hoping someone can help sort out how to get it working based on reference solution.
Slicing method based on: DAX Fridays #204: Slice by the results of a measure
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |