Forum Discussion

shakeelsyed's avatar
shakeelsyed
Icon for Helper I rankHelper I
8 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
    8 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

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