Forum Discussion
free form report
Well, you could use definitely use card visuals and I would couple that with a slicer such that each slicer only filters the correct card visuals. So, you could have a slicer for John Smith and one for Paul Jones. You can place those card visuals whereever you want. Seems like an arduous way to create a report though, even in SSRS. Trying to wrap my head around the use case.
You could also use the Visio visualization potentially and tie in your data that way. Or maybe even the new PowerApps visual.
If I understand this correctly, you are referencing the ability of SSRS to have sub-reports contained a master report? I'm not sure what the <<Expr>> fields across the top are, I'm assuming some kind of dropdown selection control? I'm guessing that the top row filters everything but that the second row only filters the individual columns? It's really tough to visualize this without a concrete example. There are too many unknowns around what that report is doing. Often, you can achieve the same effect in Power BI but have to approach the solution to the end result differently. Unfortunately, I'm not clear on the end result you are looking to achieve.
Hi,
No I'm not referring to a master detail report as you can simply use two linked visuals to achieve that.
I made a new example that's hopefully more clear. It's a report based on an Employee table. How would you create such a report in Power BI. I use the term "Free form" as I can put the data fields (called Controls by me) in any place in the report section I choose and when I view the report it just shows this layout for each record.
Well, you could use definitely use card visuals and I would couple that with a slicer such that each slicer only filters the correct card visuals. So, you could have a slicer for John Smith and one for Paul Jones. You can place those card visuals whereever you want. Seems like an arduous way to create a report though, even in SSRS. Trying to wrap my head around the use case.
You could also use the Visio visualization potentially and tie in your data that way. Or maybe even the new PowerApps visual.
Hi,
Thank you for your response.
A slicer for each employee would not work if it's a few thousand employees.
A use case would be a report used to print stickers, that require a specific lay-out.
I can't make a slicer for each sticker, so I'm afraid that's not realistic.
Thank you though for the two suggested new visuals, I'll check them out, they may indeed work.
For now I created the report in SSRS (took 5 minutes) and it works, but we want to move to a Power BI only report/analysis interface, that's why I asked.
Thank you for taking the time to advise me.
Kind Regards,
Vincent Lassauw
OK, I get that use case now. That is definitely not a use case for which Power BI was designed!!