2 Column text box?
Currently using a text box with dynamic values to show 14 measures, but the text adjusts when the filters (customer) are changed and the formating goes all wonky (second image). Am i able to insert columns into the text box? or a table? or do i need to create a template externally and fill it with the text needed?Filtering by text within text column
Hello amazing community! Does anyone know if it is possible to create a mesure which will filter the column 'purpose' and return only those rows which contain exact wording, for example, 'design' as on the below screenshot? Many thanks for any formula suggestions! AnnaClear 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 !
Check if rows contain a string value against an unrelated table
Hi, I have two tables in my dataset: Table1 is my transactions which have a description that looks like this: and Table2 is my legend table, where I define what each transaction belong to what category: My goal is to categorize each transaction based on the legend by looking for a piece of description column in the transaction column. So if a transaction contains "Desk", the column I'm going to create shows "Office Supplies". Here is what I've tried: I used a new custom column in Table 1 to check for 3 values and return true if they returned a value: List.Transform ( {"Desk", "Payroll", "Chair"}, (substring) => Text.Contains([Description], substring)) This returns a list of TRUE or FALSE based on the three examples I gave it. Potentially this can be used to get the first row that returns true and use that as a reference for the second column? I tried to do it in Excel, and essentially I had to use SEARCH fonction with INDEX and MATCH to get the category from a different table. My issue is that I have two tables that are not related and I'm not sure how to do a search for a piece of string for every row. I'm pretty new to PowerBI and I need some support please. TIA!
