Visualisation of Data-Groups without Measure

[TorstenMa]

Hi there,

is it possible to generate a Report just like that in Power BI:

I need it as a straight list of data without measures or something like that. The data is stored nearly exactly as it is printed (screenshot from IBM Cognos)

How can I achive this?

[TorstenMa]

The structure of the table/data ist fully flattened. So I think I only need a repeater or something like that, where I can say:

Take distinct values from column SB_SCHL, create a table for every distinct value und filter data by this value.

Another idea would be a Master-Detail-Grid.

I need the output one page, so I think paginatet report isn't usefull.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[TorstenMa]

I simplified my example, so I hope it gets clearer:

In the Database I have:

SB_SCHL	BestNr	ArtikelNr
1	1	A
1	2	B
2	3	C
3	4	D
3	5	E

Now I want this output:

SB_SCHL	1
Bestnr	Artikelnr
1	A
2	B
SB_SCHL	2
Bestnr	Artikelnr
3	C
SB_SCHL	3
Bestnr	Artikelnr
4	D
5	E

[lbendlin]

You seem to be looking for Paginated Reports ?

What are paginated reports in Power BI? - Power BI | Microsoft Learn

[dharmendars007]

Hello @TorstenMa , 

The visual you are asking can be replicated in Power BI considering the data coming from the table is structured to support it..Please share us the sample data so that it can help us to check further.

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN