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 everybody,
I am creating a table view in PowerBI report. Here i have to repeat the same field twice. Example
column1: employee ID
column2: employee name
coumn3: manager ID
column4: manager name
but the database table is only one, all the names are saved in the same field in database. Here how can i repeat the name column twice in the same table view in report? attached screenshot
please help
best regards,
anand
Solved! Go to Solution.
Hi @AnandAmirtharaj,
In your scenario, if you want to filter all the Manager employees, you have to identify which person is a manager. I don't know how is the source table look like, I suppose the table contains an extra column to mark which one is manager.
Import the same source data twice, then you get two same table, table1 and table2.
In query editor, select table1. Filter data rows. And add an index column.
Select table2, add an index column. Merge these two tables.
In view mode, create a new table using below formula:
Table 2 = SELECTCOLUMNS ( 'Reflect same fields twice', "EmployeeID", 'Reflect same fields twice'[Employee ID], "EmployeeName", 'Reflect same fields twice'[Employee Name], "ManagerID", 'Reflect same fields twice'[NewColumn.Employee ID], "ManagerName", 'Reflect same fields twice'[NewColumn.EmployeeName] )
If you have any other question, please feel free to ask.
Best regards,
Yuliana Gu
Hi @AnandAmirtharaj,
In your scenario, if you want to filter all the Manager employees, you have to identify which person is a manager. I don't know how is the source table look like, I suppose the table contains an extra column to mark which one is manager.
Import the same source data twice, then you get two same table, table1 and table2.
In query editor, select table1. Filter data rows. And add an index column.
Select table2, add an index column. Merge these two tables.
In view mode, create a new table using below formula:
Table 2 = SELECTCOLUMNS ( 'Reflect same fields twice', "EmployeeID", 'Reflect same fields twice'[Employee ID], "EmployeeName", 'Reflect same fields twice'[Employee Name], "ManagerID", 'Reflect same fields twice'[NewColumn.Employee ID], "ManagerName", 'Reflect same fields twice'[NewColumn.EmployeeName] )
If you have any other question, please feel free to ask.
Best regards,
Yuliana Gu
Hi Yuliana Gu,
Thank you for your valuable response. What i have done is created new data source (taking the same fields available in table1), created relationship between the 3rd column (manager) with employee id and displayed name.
Now its successfull !
Best Regards,
Anand
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |