Forum Discussion
Solved
Compare fields side by side from same dataset with grouping and filter Slicer
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...
Hi RayGn2000,
You can create two dimension tables to define current year and compared year.
Here is the output:
Here is the demo, please try it: Compare fields side by side from same dataset with grouping and filter Slicer
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
v-xulin-mstf
Community Support
Community SupportHi RayGn2000,
You can create two dimension tables to define current year and compared year.
Here is the output:
Here is the demo, please try it: Compare fields side by side from same dataset with grouping and filter Slicer
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.