Forum Discussion
Helper IHow to add new filed value to table visualization
Impactful IndividualFrom 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
- shakeelsyed
Bingo! Thanks you very much smileyhappy: .. It worked