Forum Discussion
Dynamic columns refresh issue
I tried to unpivot the month and make the pivot visualisation within the Power Bi Desktop but it didn't success.
the table that I have looks like:
Type Jan Feb March
a 1 2 10
b 15 2 1
c 12 1 6
but, in the next refresh I would have:
Type Feb March Apr
a 2 10 4
b 2 1 0
c 1 6 3
I have to select the new column (Apr) in order to see it in my dashboard.
Actually I want the dashboard always to show me all existing columns from my query (it will be always 3 last month).
I can unpivot the table to look like:
Month a b c
Jan 1 15 12
Feb 2 2 1
March 10 1 6
But is there any way to pivot it using the Power Bi Desktop?
Thanks for your help.
Yes, sorry, that was what I was suggeting, to unpivot it in Desktop. Point a query to your data and edit the query. Choose your "Type" column and then "Transform | Unpivot columns | Unpivot Other Columns", you should get a table like:
Type,Attribute,Value
a,Jan,1
a,Feb,2
a,March,10
b,Jan,15
etc.
Thanks, although I succeeded to pivot the view inside the Power BI Desktop, I'm getting the same issue, when refreshing the data and new column is added it's not automaticcaly selected in the visualisation view.
- Hi - at the moment we don't support dynamic import across a pivot table. What is the pivot table connected to? Could you go directly to that datasource instead?
I have the same issue as described in the subject, I would like to add new columns automatically (or show all columns by default) Is there any update with that functionality ?
