"text"

2 Topics

Dynamic Text in Text Box or Card based on slicer selection
I am trying to change the text in a text box or card based on a slicer selection. For example, if i select a country "Afghanistan", I want the text box to read "The War in Afghanistan began in 2001". If I select "Ukraine", I want the text to read "Ukraine was attacked in early 2022", and so on. I've seen similar inquiries with "VAR, RETURN, IF" DAX solutions, but I can't seem to get them to work. The column name is "Country of origin" and table name is "Orgin/Destination" Thank you
dilledille
2 years ago Place Custom Visuals Development Discussion
2.1KViews
0likes
2Comments
Find multiple substring (not defined a priori) in a text
Hello everyone, I'm new to this forum and also to using Power BI Desktop. I was trying to solve a small issue I'm encountering. In practice, I need to be able to find words within a text contained in a row, let me explain it better. In a cell in column A, I have the string "A,B,C". In the cell in column B, I have the string "A,B,C,D,E,F,G,H,I". So, I need to check if "A", "B", and "C" are in "A,B,C,D,E,F,G,H,I". Similarly, if I have the string "C,B", I need to be able to check if "C" and "B" are in "A,B,C,D,E,F,G,H,I". The strings in the cells of columns A and B do not have a fixed number of elements; they can vary. The results is better explained here: Column A Column B Results A,B,C A,B,C,D,E,F,G,H,I True C,B A,B,C,D,E,F,G,I,N,P,Z True D,Z A,B,C,I,Z False Thanks to everyone who will help me
Solved
Anonymous
2 years ago Place DAX Commands and Tips
1.2KViews
0likes
4Comments