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?
Helper IThanks 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
- shakeelsyed
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
Hi Shakeel,
If [Share of portfolio] is a column, you can add it in the Rows of a Matrix.
Best Regards,
Dale