cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adanecito
Post Patron
Post Patron

How to have duplicate columns in table visualization

Hi All,

I need to have two identical columns (from the same table in dataset) in the Table visualization. I googled and could not find what I am looking for. The customer wants two columns called "fund" such they are grouped near a set of other columns.

 

I hope that make sense.

1 ACCEPTED SOLUTION
kentyler
Solution Sage
Solution Sage

Here I've create a "duplicate" of the index column using a calculated column in DAX. I could also do something similar in power query. Once I've done this I can place both columns on a table display. 

 

 

duplicate column.PNG

 

I'm a personal Power Bi Trainer I learn something every time I answer a question. I blog at http://powerbithehardparts.com/

The Golden Rules for Power BI

  1. Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
  2. Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
  3. Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
  4. Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result  to check on your steps along the way.




Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

3 REPLIES 3
danextian
Resident Rockstar
Resident Rockstar

Hi @adanecito,

Aside from creating a duplicate colum in DAX or Power Query as what @kentyler, you can also actually use a column/measure more than once in some visuals. The caveat is that the same column/measure used more than once in the same visual can have only one name in that visual such that, if you rename Column1 to Column2, all instances of that column in that visual will all be renamed Column2. 

Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
kentyler
Solution Sage
Solution Sage

Here I've create a "duplicate" of the index column using a calculated column in DAX. I could also do something similar in power query. Once I've done this I can place both columns on a table display. 

 

 

duplicate column.PNG

 

I'm a personal Power Bi Trainer I learn something every time I answer a question. I blog at http://powerbithehardparts.com/

The Golden Rules for Power BI

  1. Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
  2. Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
  3. Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
  4. Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result  to check on your steps along the way.




Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

Thanks! I took your suggestion and went into Power Query and selected the column I wanted to duplicate and did a right button select and the list of options popped up and one was duplicate and worked like a charm. I will be handing over the report to a business analyst so I need to keep it as simple as possible till they learn more.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors