Forum Discussion

sabariprabu's avatar
sabariprabu
Frequent Visitor
3 years ago

Power BI Matrix Table - Does not show the Text comments mapped correctly

Please see the below table structure.

 

I have Three DimTables - Description, Date, Comments and One Fact Table linked to all Dim Keys.

In DimComments we have a field 'Comment' with the combination of Category, Product and different Year and Month.

 

I am using a Power BI Matrix table where CategoryName and ProductName are kepts in Rows Hierarchy from DimDescription.

 

DimDate is kept as a slicer to select specific Year and Month. It is a Radio button so only one Year/Month will get selected.

 

In the values section of Matrix table I drag and drop the Amount Field from Fact and also the Comment field from DimComments. The problem which I am facing is Comment field is getting as blank after I drag and drop. 

 

I done the same scenario in a normal Power BI table and I can see the comments getting mapped correctly. But in Matrix table when i give the comment field, it is taking First Comment by default and showing as blank.

 

Please help.

 

In below image 1st there is a Matrix table with comments in values field. And in next we have comments in normal table and it maps correctly.

 

 

 

 

 

 

 

No RepliesBe the first to reply