SLICER - SELECT ALL WHEN SEARCHING
For my slicer I have enabled the option to select all, but when i search for something specific the option to select all is not there. Is there an option to add it? without any searching select all appears when i write on search text box i do not have the option to select all
Searching a slicer in my Direct Query report blows it up (ORA-00904)
Good afternoon! Anonymous and I are building a report that performs a Direct Query to an Oracle database with a custom SQL query (that we feel is optimized) through a gateway. We originally had several search boxes with the Text Filter visual added, but when we would search we would immediately lose all the visuals. We replaced this with a slicer. It takes a moment for all the values to load, but when we select one it works. If we attempt to search the slicer at all, we lose the slicer visual with an ORA-00904 (invalid identifier) error. If the slicer has loaded all the selections, is it passing the search through SQL? I assumed it would just search in local memory. Do we need to do something funky to the SQL query? Is this just an optimization issue? Hopefully we're not the only people fighting this. Thanks in advance!
Clear a Search text box in a slicer field
Hi , The search text entered in the slicer won't clear even after hitting eraser OR using book mark to clear default selection . We're seeing this issue on both on Power BI Desktop and Power BI Report Server ( not sure about Power BI Service, because we're using On premise PBI Report server ). Could you please let us know the solution to fix this issue . If this is expected behavior, kindly fix this in upcoming versions . Thanks in advance !Count appearance of string in a comma-separated data column does not count values after the first co
I have two tables: Products table has a single column with one product per field: List table has several columns but the column I'm interested in has fields that can have as little as one product to as much as 17, all separated with a comma and no spaces in between: The issue I'm facing and need help with is to correctly count each product either, ideally as as a measure. I tried two measures but they both gave me an incorrect count of blanks; there are no blank values either table. What I found is that both measures count only the *first* value they find in the List column and then continue counting subsequent rows: How can I correctly count all values in each field from the List table and have zero "blank" counts? Thanks!
Parameter Search not working in Power BI Online
Hello, I am trying to understand the search box that shows within the published Paginated Report on Power BI Online. On inital load, the search function works as expected. However, once the report is ran, when using the search function again it won't update the report and it will keep the previously selected parameter instead of using what is within the search. What can be done to make it so the user doesn't have the refresh the report everytime in order to search for a particular parameter. Thanks!
Lookup value within date range
I'm looking for a dax formula for a calculated column, which searches by name and between two dates. In the picture below the explanation. I'm looking for a DAX formula (calculated column) for the orange column in table_1. I have found many similar questions with solutions on the internet. However, those solutions just don't work. I hope someone can help me with the final solution through this community site. Thanks in advance for the help! Bas.Text Filter visual not working in Report Server? Alternative?
Can anyone confirm if the Text Filter visual (Version: 1.2.1) is supported on Report Server? Works great on Desktop but does not appear when publishing to Report Server. If the answer is no, any suggestion on how to implement a basic text search on report server? I know I can turn on search in a slicer, but dont want to show search results as a drop down in the slicer (search results are shown in a separate table visual) Thanks
Search In Different Order
I'm looking to have a search field that looks in a table where it searches the same words, but the words could be in a different order. In excel, it would be similar to the contains and contains filter instead of the exact filter. Example Description Field: Pen Blue Medium Bic In the search field if "blue pen" is entered I would like for this description to come up. It's only coming up if I type the words in the exact same order. Eg. "Pen blue", "blue medium" & "medium bic" Thanks in advance for your help! 🙂 Laurinda
