Compare fields side by side from same dataset with grouping and filter Slicer

Question

I have a dataset which has historical data from year to year. I want to compare what changed in year to year using slicer by taking data from the same dataset. I can even duplicate the data source if required.&nbsp;The data coming from SQL looks like this&nbsp;&nbsp;I want to build a PBI matrix report by comparing data from 2 Years data. There are 2 dropdowns for year so that I can compare with any year data with another year.&nbsp;&nbsp;any advice is appriciated. Can this be achievable in PBI report with one dataset?

v-xulin-mstf · Accepted Answer

Hi RayGn2000,&nbsp;You can create two dimension tables to define current year and compared year.Here is the output:&nbsp;Here is the demo, please try it: Compare fields side by side from same dataset with grouping and filter Slicer&nbsp;Best Regards,Link&nbsp;If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Table Group , Custom comparer

How to get Dataset Id and Group Id?

Community User Group Experience

Refresh dataset api