Forum Discussion
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.