Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Good Morning!
Currently in my slicer of filter values are with data type i.e whole interger. and the values are shown with 12 digit number like below snapshot. Can you please suggest, If data type change it to text then we will get serach option, but it is not correct way. Please suggest how to fix this issue(suggest with snapshots please) or any DAX or any other way.
Kindly help me to fix this issue. Thanks in Advance.
Solved! Go to Solution.
Yes, convert the datatype of the column to Text type and you're good to go with the filtering.
OR
If you want the existing column to act as Number column + You want to search & filter the data then : duplicate the column to create another column and set the data type of the duplicated column to TEXT type and pass it in the slicer.
Thank you.
If my answer helps you, please mark it as solution.
Thanks for your help.
Yes, convert the datatype of the column to Text type and you're good to go with the filtering.
OR
If you want the existing column to act as Number column + You want to search & filter the data then : duplicate the column to create another column and set the data type of the duplicated column to TEXT type and pass it in the slicer.
Thank you.
If my answer helps you, please mark it as solution.