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,
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.
Hi v-saisrao-msft , thank you so much for the feedback. When I use both Yearly and Monthly Attrition calculation, how would I add them in the same dataset?
Hi v-saisrao-msft , thank you so much for the feedback. I can see how this would work in Power BI. My question was in reference to Report Builder. How would I ensure that:
1. The Dataset includes both Attrition calculations for Year and Month because there are 2 separate calculations depending on the Year or Month shown in the visual.
2. Showing on the columns the Years and Current Year, with the last 3 months.
I hope that helps
Kind Regards