Japanese characters as blank

[Remek1]

Hi Guys,

I'm working on one project where I Have two tables and both have some keywords, first table has different metrics from 2nd table, business wanted to see both metrics next to each other,

There are some keywords in 1st table that doesn't apperar in 2nd table, I Can't append tables because they are different in 80%, So I created BridgeTable overall this works well but I Do have some Japanese characters that don't show in matrix when I try to Visualize the data (it shows blank)

Please see below keyword from Bridge Table:

When I Try to Visualize data I Have blanks (biddedkeyword comes from orginal table, keyword is from BridgeTable that I have created usuing Summarize, 

Any ideas why Keyword does not show in visual? Is there anything That I Could do from PBI perspective, or should I build some Views in database? I Do have circular dependecy wehn I try to build Bridge in PQ

Thanks

[v-stephen-msft]

Hi @Remek1 ,

Are you sure it's a character issue, or is the relationship causing the characters not to be displayed? You can try putting other fields from the table where the characters are located into the visual to see if they appear.

Solved: blank values with relationship - Microsoft Power BI Community

Solved: Blanks appearing in visuals - Microsoft Power BI Community

Handling BLANK in Power BI. How to cope with blank values in Power… | by Nikola Ilic | Towards Data ...

Best Regards,

Stephen Tao

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