topic Re: Add Search capability to a numeric type field with out transforming data in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4253219#M11640 <P>Cannot reproduce -</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1729639116082.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1187374iC51B56279E844A0B/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1729639116082.png" alt="lbendlin_0-1729639116082.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_1-1729639128799.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1187375i3EE0BE2B3B39C6C1/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_1-1729639128799.png" alt="lbendlin_1-1729639128799.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 22 Oct 2024 23:18:54 GMT lbendlin 2024-10-22T23:18:54Z Add Search capability to a numeric type field with out transforming data https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4248812#M11605 <P><STRONG>Problem:</STRONG><SPAN>&nbsp;</SPAN>I need to add a search capability to a userID field, which is of numeric type. However, it seems that search functionality is only possible on text type fields.</P><P><STRONG>Constraint:</STRONG><SPAN>&nbsp;</SPAN>There are restrictions on making changes to the model or transform data step, and there's a live connection set to the data.</P><P><STRONG>Attempts So Far:</STRONG></P><UL><LI>I can't change the data type in the model view or use advanced query because that requires a transform data step.</LI><LI>I can't create a calculated column using DAX, as I couldn't find any option to create a new column in the report.</LI><LI>I tried creating a measure to extract the userID from other columns, but creating a measure on a non-calculated column is not supported.</LI></UL><P>Does anyone have any suggestions on how to tackle this issue or if any of my observations above are incorrect? Any help would be greatly appreciated. Thanks!</P> Fri, 18 Oct 2024 20:44:04 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4248812#M11605 SrinathLM10 2024-10-18T20:44:04Z Re: Add Search capability to a numeric type field with out transforming data https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4248855#M11606 <P>Add that userID field to the filter pane, for example as "Filters on this page"</P> <P>&nbsp;</P> <P>Note: There is a 1 million row limit.</P> Fri, 18 Oct 2024 21:56:34 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4248855#M11606 lbendlin 2024-10-18T21:56:34Z Re: Add Search capability to a numeric type field with out transforming data https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4248913#M11607 <P>Thanks for the reply&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/100342">@lbendlin</a>&nbsp;Since the field is of numeric type the filter pane does not allow you to search</P> Sat, 19 Oct 2024 01:47:38 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4248913#M11607 SrinathLM10 2024-10-19T01:47:38Z Re: Add Search capability to a numeric type field with out transforming data https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4253219#M11640 <P>Cannot reproduce -</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1729639116082.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1187374iC51B56279E844A0B/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1729639116082.png" alt="lbendlin_0-1729639116082.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_1-1729639128799.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1187375i3EE0BE2B3B39C6C1/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_1-1729639128799.png" alt="lbendlin_1-1729639128799.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 22 Oct 2024 23:18:54 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4253219#M11640 lbendlin 2024-10-22T23:18:54Z Re: Add Search capability to a numeric type field with out transforming data https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4256670#M11671 <P><SPAN>Sorry, I did not understand the comment 'Cannot reproduce.' As you can see in the snapshot, we cannot search for numeric type.</SPAN></P> Thu, 24 Oct 2024 16:59:41 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4256670#M11671 SrinathLM10 2024-10-24T16:59:41Z Re: Add Search capability to a numeric type field with out transforming data https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4256724#M11672 <P>I can search for any number in that filter?</P> Thu, 24 Oct 2024 17:47:09 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Add-Search-capability-to-a-numeric-type-field-with-out/m-p/4256724#M11672 lbendlin 2024-10-24T17:47:09Z