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.
I am trying to combine 3 text columns into a single, "master" column that can more easily be used for search.
Example:
Table_Contacts
Column_SalesRep1
Column_SalesRep2
Column_SalesRep3
I have tried several approaches, created a new Table with just the fields I want to search against, but the Slicer isn't working.
Thanks for any suggestions!
Solved! Go to Solution.
You could unpivot the 3 columns and get all the values in one column that you could use in the slicer and/or the search column. If you can't do that, you can use SELECTCOLUMNS and UNION to combine the 3 columns into a single column of distinct values.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You could unpivot the 3 columns and get all the values in one column that you could use in the slicer and/or the search column. If you can't do that, you can use SELECTCOLUMNS and UNION to combine the 3 columns into a single column of distinct values.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Why not just concatenate the columns in the query editor (or with a DAX column)? A custom column in query with
= [Column_SalesRep1] & " " & [Column_SalesRep2] & " " & [Column_SalesRep3]
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat, so this solution DOES work for search. (Thanks!) Now, I'd like to use a Slicer where all of the Sales Reps are listed in the drop down (not combined).
Thanks Pat for the suggestion! I did try this, but it's combining the Sales Rep names by Account in a single cell. I'd like one Sales Rep per cell. ???
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.