how to display a Text column all values in a Matrix Visual?

[Anonymous]

Hi All,

I have a table as shown below. Period column contains Data as Mid-year, End-Year for all years.  I want to display Category as a Row, Period as a Column and NetIMPact and WC Impact as values of each row.

When i am trying to do this using Matrix visual, only First value of the column(Net Impact/WC Impact)- are displaying as these are Text columns.

When I use ID column also, in the matrix visual, then i am able to see all the values? But, here Period information is not displaying side by side.

User want to compare last two periods information side by side.

How can I overcome this issue.

ID	Period	Category	NET Impact	WC Impact
1	FY17-MidYear	Financial	C5	B4
2	FY17-EndYear	Support	C4	B4
3	FY17-MidYear	Category 2	D5	D4
4	FY17-EndYear	Category 4	A4	A5

[v-cherch-msft]

Hi @Anonymous

When you drag text column to value field in Matrix, they will auto switch to summary mode(last, first, count).You may create an index column to provide the uniqueness of rows. Please refer to the work around in this post . You may turn on the 'Show on rows' to compare last two periods information side by side.

Regards,
Cherie

[Anonymous]

Hi Cherie,

Many thanks for your help here. 

Here as mentioned, using Index column we can display all the values in Matrix visual. But using Index, we cannot display values side by side as Index value is unique for each row for the year. Due to column Headers are displaying side by side but using this user cannot compare values as it's displaying unique values. First all the rows displaying for year 2017 then after completing all 2017 records, then 2018 records are displaying.

We have a requirement to compare text column ( risk Matrix values ) year by year. I am unable to compare using Table visual, Matrix visual.

Please suggest if any alternative solution or best visual do this.

Thanks,

Srinivas

[v-cherch-msft]

Hi @Anonymous

I'm afraid i cannot fully understand 'display values side by side'.Could you give an example about your expected output with your sample data?Please check if the work around in this post could help you.

Regards,

Cherie

[Anonymous]

Hi Cherie,

I am Sorry for the delay in response.  As Shown below table we have a column Period and it contains all MidYear and EndYear information. NET, WC column are risk ratings for that period.

.Sample DAta Table

As shown here, If I use Index Column  first 2017 one Period informtion displayed then next row onwords next period rows displayed. Expected result is Row 1402, 449 should display side by side then rating can be compare for the respective period.

Sample Power BI Matrix visual

 Hope this will help to understand the issue.

Thanks,

Srinivas S