Forum Discussion

madawak's avatar
madawak
Frequent Visitor
8 years ago

Display VARCHAR values in a Matrix Table

Hi,   I have a table with two columns as below;   Assessment   Result Test 1              84 Test 2              74 Test 3              A     I'm expecting to display these results in a Mat...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Create a Pivot in the Query Editor.  In the Query Editor, click on the second column's heading and click on Pivot column.  In the Aggregation drop down, select "Dont aggregate"

 

Hope this helps.

madawak's avatar
madawak
Frequent Visitor
8 years ago

Hi Ashish,

 

Thanks for your message.

 

I'm using a SSAS tabular model to bring the data into Power BI Desktop and doesn't seem to give me Pivot column option in this case.