Debbie Edwards on 12 Jun 2023 08:33:35
At present there is no way in power BI to display a table which doesn't repeat data in a column. The ideal is to have this
Objective Task Result Description
Task 1 10 Desc 1
Objective 1 Task 2 11 Desc 2
Task 3 12 Desc 3
Task 4 4 Desc 4
----------------------------------------------------------
Task 1 4 Desc 1
Task 2 22 Desc 2
Objective 2 Task 3 5 Desc 3
Task 4 56 Desc 4
Someone said that you can try a matrix but this doesnt work at all. You get
Objective
Objective 1
Task 1
10
Desc 1
Objective 1
Task 2
11
Desc 2
the above is what customers always want. Could you have a look at getting this added into the Table Visual as functionality so we can group on higher level data items in a column so it isn't repeated