Dimension column empty in table even though values present in the query

[danisharoon]

The dashboard has four dimensions and one fact. For the purposes of the question we are only concerned with two dimensions and one fact. When I create a table using these, the market name is not showing up.

I have attached the pbix file for your reference.
https://drive.google.com/file/d/1kZ2mSiwgIy-Pyg11VMGOmrgMynwnz_3X/view?usp=sharing

[MahyarTF · Accepted solution]

Hi,

Change the Fact_size_markets[Market id]'s type to "Whole Number"

Appreciate your Kudos and please mark it as a solution if it helps you