Forum Discussion
Making Individual Measure value as Slicer
Hi All,
I have a Measure which will only have two values such as 'Manual Value' and 'Auto Value'. This measure value is based on comparison between two other measures. Like if (SUM(Manual Value)< SUM(Auto value),Manual Value, Auto Value)
Like to use these measure values as a slicer. I have seen cases measures can be used in slicer. But, is it possible to use individual measure values in slicer?
Hi spnaveenkumarr ,
You can refer to this blog:https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
Or you can replace measure with a calculated column.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- baghdadi62Resolver III
Hi, It is not possible to use measure in a slicer. you can create new column for that.
- V-lianl-msftCommunity Support
Hi spnaveenkumarr ,
You can refer to this blog:https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
Or you can replace measure with a calculated column.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.