I want to pull a custom column values to my visual

[sankaralingam]

Hi, 

Below is my source , i have visualized sep-21 values in my report now data sheet owner has added a new column oct-21, Now i need to pull oct-21 values to my visual (so bascially sep-21 values in the visual should be replace with oct-21 value) . is that possible ?

basically every month i will get new columns like nov-21, dec-21 so the latest value should be displayed in my visual without modifying anything. 

Kindly help me on this.

Thanks

[Gaurav_Lakhotia]

Hi @sankaralingam,

I this case, I would suggest in Power Query Editor, you should "Unpivot Other Columns" or "Transpose" the table/column so that you will get all the month & the % values in 2 separate columns.

Month	Value
Sept-21	100%
Sept-21	100%
Oct-21	93.20%
Oct-21	72.70%

You will get output table something like above.

Now, you don't have to worry about new columns.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

Thanks