Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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.

 

 

IDPeriodCategoryNET ImpactWC Impact
1FY17-MidYearFinancial C5B4
2FY17-EndYearSupportC4B4
3FY17-MidYearCategory 2D5D4
4FY17-EndYearCategory 4A4A5
Need Help

4 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-cherch-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        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