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 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.
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 |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |