Data is not showing up with values in Matrix Visual using SSAS Live Connection

[Suresh4vkb]

We have a requirement to show or hide the columns in Power BI Report, able to implement with matrix visual. But when we are using SSAS live Connection for Data,

Values are not showing the actual data (with First or Last options), it is showing with aggregated counts. When we use the same data with SSAS Import or SQL Data with Import, values are showing. 

Below is the sample data

Username	Company	Country
SA11001	ABC	India
SA11002	ABC	India
SA11003	ABC	India
SA11004	XYZ	USA
SA11005	XYZ	USA
SA11006	XYZ	USA

Values are showing as count

Username	Count of Company	Count of Country
SA11001	1	1
SA11002	1	1
SA11003	1	1
SA11004	1	1
SA11005	1	1
SA11006	1	1

But we need to show data as below with SSAS Cube live connection. Please suggest how to resolve this issue 

Username	First Company	First Country
SA11001	ABC	India
SA11002	ABC	India
SA11003	ABC	India
SA11004	XYZ	USA
SA11005	XYZ	USA
SA11006	XYZ	USA

[V-pazhen-msft]

@Suresh4vkb 
Do you have the below option to choose? Change Count to First.  

Or you can create 2 measures for each column, and use the measures instead of columns.

country measure=max([country])
company measure= max([company])

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Suresh4vkb]

Thanks for your response. The first and last options are not displaying when we use data from SSAS Cube live connection mode. If we choose SQL/SQL import/SSAS Cube Import/Excel for data then the First and Last options are displayed. We are hoping it might be related to the data type issue

[FarhanAhmed]

it should not be happening if Company and Country are coming as Dimension Values. Are you using Table Visual or Matrix visual for your report?

[Suresh4vkb]

Thanks for your response. I am using Matrix visual for the report