Forum Discussion

rit's avatar
rit
New Member
5 years ago
Solved

Visualise - Need to merge unique values in a table

I am new to PBI.  My use case is to display work items from ADO as well as related work items that are blocked by the first.  Ideally, I'd like the data to be displayed as;

 

At the moment, I can only get the data to display as;

 

 

 

 

 

or, using a Matrix, like this;

 

 

 

 

 

Is what I'm seeking in the first image even possible? 1 row splits to 2?

Split row
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, rit 

     

    I think It's hard. The rows and columns in the visual have context and can't be merged like in excel. You may only use matrix to achieve a similar effect.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, rit 

     

    I think It's hard. The rows and columns in the visual have context and can't be merged like in excel. You may only use matrix to achieve a similar effect.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.