line chart shows blank values

[lawada]

hello,

i have created a measure that concatenate numerical value and string . it shows data correctly in a table visual but when i use a line chart all data become blank

table:

line chart:

 the measure i created depends on a filter, when filter is selected measure will display value without a $ sign and when filter is not  selected measure will display value with $ sign.

the string in my measure was to add the $ sign part to the number

[ValtteriN]

Hi,

Instead of concatenate try using FORMAT. So something like: FORMAT([Your measure],"$ #.#").

Here is an example:

FORMAT(10000000,"$ #,#")

The problem is that if you use string functions your values are string and not actual numbers. This is why the line chart is not working.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[lawada]

value is still blank in the line chart even after changing the concatinating part

[V-lianl-msft]

Hi @lawada ,

Could you share a sample pbix after deleting sensitive data so that we can check the issue

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.