Forum Discussion
Matrix Visual: Combing Two Calculations and Fields Into Visual
Hi v-saisrao-msft, I'm looking into the Paginated Report solution and learning about it first. I will revert back once I have designed the view. Thank you!
Hi asa70,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further
Thank you.
Hi v-saisrao-msft, I'm looking into the Paginated Report solution and learning about it first. I will revert back once I have designed the view. Thank you!
Hi johnt75,
Just checking in to see if you were able to design the view, and if the issue has been resolved.
Thank you.
Hi asa70,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
Hi v-saisrao-msft , Apologies for the late reply. I have started using Power BI Report Builder for the solution.
I have a question on how to put the calculations on the same table. Through my exploration I have found 2 ways:
- Creating a calculated table - How do I ensure that the Yearly Attrition calculation stills shows up and not just the Monthly Attrition calculation?
- Creating two datasets and joining the tables - How would that be efficient and will it be relevant for the problem.
I'm still trying to figure out how to build the layout of the table, maybe that's where the solution will be?
Kind Regards,
Asanele
Hi asa70,
Since you’re now using Power BI Report Builder, you don’t need to create extra calculated tables or join multiple datasets. Just connect to your existing Power BI dataset and add both the Monthly Attrition and Yearly Attrition measures into the same tablix. Paginated reports are built for this type of formatted matrix layout, and using a single dataset keeps things simpler and more efficient.
Supported data sources for Power BI paginated reports - Power BI | Microsoft Learn
Paginated reports in Power BI: FAQ - Power BI | Microsoft Learn
Data retrieval guidance for paginated reports - Power BI | Microsoft Learn
Thank you.