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.
Hello,
I have a column called clicks where i only have one value and otherwise i have blanks. I want a new column called click1 where if blank = "-" , if not blank then the value. But it doesn't seem to work because it can't combine string and values. But is I choose 0 instead of "-" it work. Do anyone have a solution for this?
Thank you in advance
Solved! Go to Solution.
Because you're not able to have a single column contain mutiple types of data you need to ensure the output is of the same data type.
I know in some programs zeros can be displayed as a hyphens (-). However, I do not see this option within Power Bi. You could always treat these values as text, but then would lose functionality.
Because you're not able to have a single column contain mutiple types of data you need to ensure the output is of the same data type.
I know in some programs zeros can be displayed as a hyphens (-). However, I do not see this option within Power Bi. You could always treat these values as text, but then would lose functionality.
Right, you would have to have your [Value] & "" in the first case and this would make it text so it would be compatible with a dash (-) character. But, now you have a text column and that may or may not be OK.
So how would you suggest the code to be?
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |