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.
Hi guys,
I wonder if it is possible to replace the blank value with something else for data that has no reference in the relationship.
If it was in SQL I could do with CASE, but bouth data is extracted from different systems (ServiceNOW using REST and Orion using SQL query ). I know I can register the missing data in ServiceNow, but I must have to treat anyway.
Any tip?
** For those who want to know how I made the shaped map, I got the global from a JSON file.
Hi @gofgabriel ,
Maybe you could create a calculated column using the function of IF to replace the blank values.
Column = IF(financials[Country] = BLANK(),"Canada",financials[Country])
Or you could try to filter out the blank values in visual level filter.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried it before but didn't work out and I have to show those data.
The problem is that the main table is not complete, so when I make the relationship, some data is represented as blank. Power BI should give us a way to rename easily the BLANK fields.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |