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 create slicer based on "ABC" Measure:
I fave following data table:
And following Measures:
ABC Column for the same SKU may have different letter, depends which Shop/Shops I am filterring.
How to create slicer based in "ABC" measure?
I cannot create conditional column, because the value is different depends the filters used by user.
Generally I need calculate "Sales" (and different parameters) for "A" products, so products with cumulative sales (20%-100%).
Cumulative sales may be different for the same product, depends the filter the user uses.
Measure can not be used in slicer but this measure can be put in a table visual with this being the only column and still not being an actual slicer can work as a filter on the basis of interactions.
@NataliaLM Slicer can not work with measure. Create a conditional column with the help of the same dax formula and use that column in slicer.
Thank You.
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 |
---|---|
109 | |
99 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
108 | |
95 | |
83 | |
77 |