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've tried creating this with the conditional column but there seems to be a bug when analyzing my text. In my "Other" output, text is showing up than contains the word "funding" so it should be the "Funding" output - but it's not. I've cleansed my text and made sure there isn't any leading spaces. Am I doing something wrong or is there a better way to go about it? Oh yea, when I filter the text containing the word "funding" that works correctly so I'm thinking there's a bug with the conditional column function.
Solved! Go to Solution.
Well I found a work around. I created a duplicate column and it works!!
@SGLake powerquery / m is case sensitive, so if its not in the same case as your condition it wont pick it up, try changing it all to the same case first usung add column / format / upper or lower case
Proud to be a Super User!
I changed it to all lower case and I'm still having the same issue.
@SGLake do you want to share your pbix? send to vanessafvg@gmail.com
Proud to be a Super User!
I'll need to modify the report so I'm not violating company policy. What's wierd is that I just took the couple columns and put them in Excel and had my pbix look at that file and it works correctly. Does that give you a clue?
@SGLake to be honest, not really lol 🙂 but it possibly has something to do with the format of the data. Have you tried doing a format trim and clean of the data first?
Proud to be a Super User!
Unfortunately yes, I've trimmed and cleansed the column.
@SGLake the only way to figure it out really is to share it i am afraid
Proud to be a Super User!
Well I found a work around. I created a duplicate column and it works!!
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.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |