Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to have a table in a cell of another table because second table is a details table. The details are coming from a different dataset. Is it possible to make it work without putting all the data together?
Thanks
Solved! Go to Solution.
Hi, @Markzolotoy
This tutorial can solve your problem very well: Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Micr... You can refer to it patiently.
According to your description, You need to create the relationship in desktop and create a summarize table,then copy the query to report builder.
Like this:
Reference:SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Docs
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.
Hi, @Markzolotoy
Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense.
If it doesn’t solve your problem, please feel free to ask me.
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.
Hi, @Markzolotoy
Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense.
If it doesn’t solve your problem, please feel free to ask me.
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.
Hi!
Unfortunately you can work only with single dataset for a group in a tablix, you may though use lookup to get values from another dataset. If you can provide more details on your datasets and end Visual targeted sketch then maybe could suggest something !
Hi, @Markzolotoy
This tutorial can solve your problem very well: Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Micr... You can refer to it patiently.
According to your description, You need to create the relationship in desktop and create a summarize table,then copy the query to report builder.
Like this:
Reference:SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Docs
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |