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
    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

Thanks for your reply Nirvana_moksh, I am new to POWER BI and trying to achieve pivot like table with table or metric visualization where I have columns like State, District, Village, No. of Customers, Month Status & portfolio Maintained (example shown in the data sample screenshot attached) and I am trying to achieved all the column mentioned above with Month column in the column headers which shows the series in sequential order, when I use the metric visual to achieve this task, its showing the data in stepping down order which is creating lot of rows to show the details. Would it be possible to show the details in one row with the multiple columns?

 

 

 

 

 Power BI ScreenshotData Sample

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

    Bingo! Thanks you very much smileyhappy: .. It worked 

  • 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