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 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
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/
Proud to be a Super User!
value is still blank in the line chart even after changing the concatinating part
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.
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 |