Forum Discussion
Field Parameters and Calculation Groups together?
Hi, AlexaderMilland
Sorry to restore you so late. After my attempts, it seems that using the calculation group cannot achieve the results you want, and it is also possible that my knowledge is too shallow. I've tried using a calculated column to determine the selected slicer contents, but the calculated column can't read the slicer value, and I can't put it in the Row of the matrix using a measure.
If you want to use parameters, you just need to create a parameter, check PaymentDate and ShipmentDate.
Then put the created parameter column in the Row of the matrix view.
When select slicer, the martix will change:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ideally what im looking at is a solution that with just 1 click
1) enables the calculation group to swap the relationship between the calendar table and the fact table
2) swaps the caterogical field inside the visual from IsNew Payment to IsNew Shipment, probably through the use of a field parameter.