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
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors