Dynamic columns refresh issue

Question

Hi,I'm having a pivot table as my source table (using SQL connection), the columns are months.When I'm refreshing the dashboard I'm expect to get new month (new column), I'm getting it from the query but the dashboard doesn't add it automatically to the chart, I have to select it in order to make it visible.Is there any solution to fully automate this process?&nbsp;Thanks!

greg_deckler · Answer

Sounds like you should submit this as an Idea although I'm not sure how that would work exactly in terms of how you would tell a visualization to display new columns automatically. That seems like that would be a very small percentage of usage.

Any chance you could unpivot the month columns and then you could do what you want automatically via grouping, etc.?

nadian · Answer

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&nbsp;&nbsp; Jan&nbsp;&nbsp; Feb&nbsp;&nbsp; Marcha&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;but, in the next refresh I would have:Type&nbsp;&nbsp;&nbsp;Feb&nbsp;&nbsp;&nbsp;March&nbsp;&nbsp; Apra&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;I&nbsp;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&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp; cJan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp; 12Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 1March&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;But is there any way to pivot it using the Power Bi Desktop?&nbsp;Thanks for your help.&nbsp;

greg_deckler · Answer

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.

nadian · Answer

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.

willt · Answer

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?

Forum Discussion

Dynamic columns refresh issue

6 Replies

Related content

Dynamic Column headers

Dynamic Column Name

Power BI Dynamic Data Refresh for Dynamic SharePoint URLs

Dynamic Variable in Calculated Columns

Dynamic column comparison of last column