Forum Discussion

Anon2020's avatar
Anon2020
Helper I
11 months ago
Solved

Matrix Showing Difference Between Two Years

I have a matrix, shown below, that I want to show the difference between the two selected years. I am unsure of the formula to calculate the difference, but when I add it to the values of the matrix,...
Need Help
Tutorial Requests
  • v-hashadapu's avatar
    v-hashadapu
    10 months ago

    Hi Anon2020 , Thank you for reaching out to the Microsoft Fabric Community Forum.

     

    I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.

     

    Thank you for being part of the Microsoft Fabric Community!

Ashish_Mathur's avatar
Ashish_Mathur
Super User
11 months ago

Hi,

Share the download link of the PBI file.

Anon2020's avatar
Anon2020
Helper I
11 months ago

Let me know if you have troublke accessing the link

  • alish_b's avatar
    alish_b
    Super User
    11 months ago

    Hello Anon2020 ,

     

    The link does not work. Please store the pbix file in a Google drive (with public permissions) or a Dropbox (again public) or a public repo in Github whichever you prefer. Please make sure that you remove any sensitive data beforehand. 
    Or, you could simply add sample data in a table format (that can be copied so not an image) and drop the measure definitions (if any) or any particular steps to recreate your visual.