Forum Discussion

danisharoon's avatar
danisharoon
Helper I
3 years ago
Solved

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

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

  • 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

1 Reply

  • MahyarTF's avatar
    MahyarTF
    Memorable Member

    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