topic Re: Visualise - Need to merge unique values in a table in Report Server

Visualise - Need to merge unique values in a table

rit — Wed, 26 May 2021 09:32:05 GMT

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?

Re: Visualise - Need to merge unique values in a table

v-janeyg-msft — Fri, 28 May 2021 02:17:13 GMT

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.

Re: Visualise - Need to merge unique values in a table

rit — Fri, 28 May 2021 08:20:53 GMT

Thanks v-janeyg-msft