Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Help when you know. Ask when you don't!
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.
Proud to be a Super User!
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
Help when you know. Ask when you don't!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |