Automatically add new fields in dataset to visualisation

[PBIuser73]

Hi. 
I have a table like this:

Project	Type	Number	Vurd
A	XX	1	Character1
A	XX	2	Character2
A	XX	2	Character3
B	YY	1	Character3
B	YY	2	Character4
B	YY	3	Character6
C	XX	3	Character2
C	XX	1	Character3
C	XX	1	Character4

The dataset will increase all the time (and column Vurd can get other values).

I pivot this dataset in PowerBi using Transform and Pivot function. 
Then the dataset looks like this:

Project	Type	Character1	Character2	Character3	Character4	Character6
A	XX	1	2	2
B	YY			1	2	3
C	XX		3	1	1

 And the dataset will look like this in powerbi:

If i get more rows in dataset and a row with Vurd Character8 is added, it will create a new column in dataset. 
This works automatically and perfect. 

So my question is:
Is it possible to automatically add those new columns in the visualisation?  

[GrowthNatives · Accepted solution]

Hi @PBIuser73 ,
I see you are facing a problem with automatically add new fields in dataset to visualisation. No, Power BI does not automatically update the visual with new columns from the Pivot when new data introduces them.

When you pivot data (using Power Query), each new value in the Vurd column (like Character8) becomes a new column.
But in Power BI visuals, fields (columns) must be manually added to the visual.

Even though the data model updates, the visualization structure is static unless manually changed.

✅ Workaround Options

1. Unpivot + Matrix Visual

Instead of pivoting, keep data normalized and use a Matrix visual:

• Keep columns: ProjectType, Number, Vurd

• Put:

  • Rows: ProjectType

  • Columns: Vurd

  • Values: Count or Sum of Number

Now, when new Vurd values appear, they’ll automatically show up as new columns in the matrix visual.

You will now see a dynamic matrix like:

2. Dynamic Measure Table (Advanced)

If pivoting is required and you want full control:

• Create a measure for each Vurd (e.g., Character1 Count)

• Then use field parameters to toggle or display selected columns.

But this still doesn’t auto-detect new columns without updating the report manually.

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀

[PBIuser73]

I tried to use your alternative 1. And it did what i expected. But is it possible to make a new column to the right as a average of the values in all columns?
Like this:

[GrowthNatives]

Thanks! and about calculating averages across all character columns per row.

🛠️ Use DAX to calculate average per ProjectType

1. Create a DAX measure for row-level average

Average by Project =
VAR ThisProject = SELECTEDVALUE('YourTable'[ProjectType])
VAR Total = 
    CALCULATE(SUM('YourTable'[Number]), ALLEXCEPT('YourTable', 'YourTable'[ProjectType]))
VAR CountVurd = 
    CALCULATE(DISTINCTCOUNT('YourTable'[Vurd]), ALLEXCEPT('YourTable', 'YourTable'[ProjectType]))
RETURN
    DIVIDE(Total, CountVurd)

🔍 This counts the number of unique characters (Vurd) per ProjectType and divides the total to get the average.

2. Add this measure to the Matrix visual

• Add Average by Project as a value in the matrix.

• Right-click it → "Show on rows" = Off so it appears as a new column to the right.

This will give you:

ProjectType Character1 Character2 Character3 ... Total Average

A	1	2	2	...	5	1.67
B	...	...	...		6	2.00
C	...	...	...		7	2.33

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More] 

[PBIuser73]

Thank you for answer. I made the value. But i am not able to find the option "show on rows".

[PBIuser73]

Thank you! 🙂