Forum Discussion
Visualisation of Data-Groups without Measure
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?
5 Replies
You seem to be looking for Paginated Reports ?
What are paginated reports in Power BI? - Power BI | Microsoft Learn
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
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.
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-Forum/ba-p/963216
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/1447523I 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
