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.
Hi all,
I had to modify the content of a column in a table .Used a calculated measure as below
Mod_Country=if(max(Country)="US","USA",Country)
Now I need to show the Mod_Country as a slicer so the user can select Countries. For some reason Power BI is not accepting measures as part of Slicer Categories, whereas, I can achieve required result if I used a Calculated Column for Mod_Country though.
Is this an expected behaviour?
Solved! Go to Solution.
Yes, this is expected behavior. You must populate a list of values into a slicer for selection. So it's not possbile to support putting measure into a slicer. A measure is a formula that the calculation is always aggregated, it need to be sliced so that you can get corresponding result for each entry.
In this scenario, you should always use a calculated column to achieve your requirement.
Regards,
Yes, this is expected behavior. You must populate a list of values into a slicer for selection. So it's not possbile to support putting measure into a slicer. A measure is a formula that the calculation is always aggregated, it need to be sliced so that you can get corresponding result for each entry.
In this scenario, you should always use a calculated column to achieve your requirement.
Regards,
Hey,
currently measures are not supported on sliceres, so yes this is an expected behavior.
This may change in one of the future releases, but for now I'm not aware of an ETA.
Regards
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |