Intellipaat Back

Explore Courses Blog Tutorials Interview Questions

Dynamic column names in power bi

0 votes
2 views
in BI by (11.1k points)

How can I export excel files for PBI reports,I want to create columns which base upon this cells

Table structure

Like column names consist of  Apr-17, May-17, ..., Dec-17, Jan-18,..., Mar-18.

How can I do this?

1 Answer

0 votes
by (22.5k points)
edited by

enter image description here

  • To import a file, create an query

enter image description here

enter image description here

  • Select "Transform" -> "Use First Row As Headers" in the query editor
  • Transform" -> "Unpivot Columns"

enter image description here

  • Rename columns

 Want to learn more about Power Bi, Enroll in this Power Bi Course

Related questions

0 votes
1 answer
Dynamic Link upon User Slicer Selection in Power BI
asked Feb 14, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
How can I make KPI card's target goal dynamic in Power BI?
asked Jan 4, 2021 in BI by Chris (11.1k points)

31k questions

32.9k answers

507 comments

693 users

Browse Categories

© COPYRIGHT 2011-2024 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

...