Hi everyone,
I have an Excel Table several columns that contain numbers but a few cells contain "N/A".
When I load this table into Power BI and add these columns in a Table Visualization, the cells with "N/A" are blank. I am curious to know if it is possible to have "NaN" or "N/A" and Numbers in one column in Power BI table visualization. Meanwhile, the total aggregation works well.
Regards,
I have an Excel Table several columns that contain numbers but a few cells contain "N/A".
When I load this table into Power BI and add these columns in a Table Visualization, the cells with "N/A" are blank. I am curious to know if it is possible to have "NaN" or "N/A" and Numbers in one column in Power BI table visualization. Meanwhile, the total aggregation works well.
Regards,
