Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |