Display Issue with Text Column in Power BI Grid MAQ

[janinedev]

Good day BI community,

I'm relatively new to Power BI and I'm encountering an issue with a text column when using the GRID MAQ for pagination in my table visual.

The problem is that when I display the text column in the table, it shows values like "NAN/NAN/0 NaN:NaN PM," which are clearly incorrect. However, when I use a normal table visual, it displays the correct values.

I suspect that this issue might be related to the GRID MAQ, but I'm not sure how to resolve it. Can anyone provide guidance on how to make the text column display correctly in the GRID MAQ?

Any help or insights would be greatly appreciated. Thank you!

LEFT IMAGE WITH BY GRID . RIGHT IMAGES NORMAL TABLE VISUAL

[v-yiruan-msft]

Hi @janinedev ,

Are you creating the visual Grid by MAQ Software? If yes, it can display the normal date text in my side. What's the version of your Power BI Desktop?

Best Regards

[janinedev · Accepted solution]

Good day @v-yiruan-msft, 
Yes i'm using the  Grid by MAQ Software and i'm also using POWER BI Desktop. 
My POWER BI version is Version: 2.121.942.0 64-bit (September 2023).

I think it's because of the pipe  '|' that seperate the date and time.  What I did was create a new column that replace the '|' with empty string '' and it display correctly.

Attached below is the screenshot of POWER BI Version