Forum Discussion

shakeelsyed's avatar
shakeelsyed
Icon for Helper I rankHelper I
7 years ago
Solved

How to add new filed value to table visualization

Hi,    I have a report which is published to the web where I have created a table and changed the month column to column headers using power pivot (ex. column 2018-01, 2018-02 and so on) and refres...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi shakeelsyed,

     

    You can achieve it by disabling the "Stepped layout" like below.

    How_to_add_new_filed_value_to_table_visualization

     

     

    Best Regards,

    Dale

shakeelsyed's avatar
shakeelsyed
Icon for Helper I rankHelper I
7 years ago

Hi Dale & All

 

Would it be possbile to achive table shown in screenshot shot, where I have columns like state, % portfolio & month on month 

DPD % by different buckets.

 

earlier in my above example I had string where i was able to generate static details by doing stepped level off, but in this case I have intiger where i would want to sum up the details in one column and the rest of the table should show state by month on month DPD % by bucket. is it possible?

 

Please let me know if I am unclear in explaining my problem.

 

Regards,

Shakeel

 

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

Hi Shakeel,

 

If [Share of portfolio] is a column, you can add it in the Rows of a Matrix. 

 

 

Best Regards,
Dale

  • shakeelsyed's avatar
    shakeelsyed
    Icon for Helper I rankHelper I
    7 years ago

    Hi Dale, 

     

    I have done that but its not aggregating values in [Share of Portfolio] column and segregate the column with different amount & %'s, I want to summarize this column and in show the corresponding month details in metrix columns.

     

    Regards,

    Shakeel

     

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

      Hi Shakeel,

       

      I'm afraid the Matrix visual doesn't work like that. I would suggest you vote up this idea.

       

       

      Best Regards,
      Dale