Forum Discussion
Field Parameters and Calculation Groups together?
Anonymous in case you didn't see my reply as it looks like it wasn't linked to you 🙂
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.
Could you post the PBIX file since it looks like you left out some steps.
The photo with the field parameters is based on the date field, while the slicer in last photo is based on the IsNew category?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.