Forum Discussion

asa70's avatar
asa70
Advocate I
11 months ago
Solved

Matrix Visual: Combing Two Calculations and Fields Into Visual

Hi all,    I hope you're all doing well.   I have a task where I need to showcase two calculations on a Matrix Visual:   A Yearly Calculation for the ones in Green  A 12 Month Trail...
Need Help
  • asa70's avatar
    asa70
    10 months ago

    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!

asa70's avatar
asa70
Advocate I
9 months ago

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?

  • asa70's avatar
    asa70
    Advocate I
    9 months ago

    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