Forum Discussion
Solved
Why would a simple filter not work?
I can't understand how something as basic a filtering go this wrong, but it apparently doesn't work in my current case. Can someone see a reason? I filter Table visual by "Category ID" field. I wan...
Hi plew
Thank you for the update. Since access to the underlying data model is limited and the report is operating in DirectQuery mode, a practical approach would be to create a calculated column within Power BI to convert the CATEGORY_ID into text. This method helps to avoid floating-point issues without requiring any changes to the data source. Once the calculated column is added, use this text-based column, such as CATEGORY_ID_TEXT, in all slicers, filters, and visuals throughout the report. By using a text column for filtering, the report ensures consistent and accurate results, as text comparisons are not affected by numeric precision limitations.
Thank You.
