Forum Discussion
Helper IHow 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 refresh the data everyday and when month ends a new month added to the data that new column is being added to dataset but not getting added to the report visualization for that I am manually refreshing the desktop file and adding new month column to the table value filed (ex. till 31st Aug 2018 its working fine but on 1st Sept 2018 new month column is not added to the table).
is there any work around on this process where the desktop file automatically add the incremental date value to the table visualization, I have attached the screenshot of the report.
Thanks in advance
Regards,
ShakeelPower bi desktop screenshot
9 Replies
nirvana_mokshImpactful Individual
From my usage and understanding, I dont think PBI has the out of the box 'Add new columns automatically' functionality and that is to avoid addition of unwanted columns to visuals. To make the process easier maybe you can do this addition from the Service instead of doing in the pbix file and then re-publishing?
shakeelsyedThanks 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
Microsoft Employee
- v-jiascu-msft