Forum Discussion
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.
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.
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
- 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
- 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
- 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.
- 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.
3 Replies
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.
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
- 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
- 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
- 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.
- 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.
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.
Hi Anonymous,
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.
