Forum Discussion
Field Parameters and Calculation Groups together?
Guess it wasn't super clear since you couldn't open the model.
IsNew Payment/Shipment are categorical fields, they contain text values such as (New, Returning, Reactivated).
I want to use it as a cateogrical field inside say a matrix visual on a row low. So it cannot be a measure, it has to be a dimension. That's why i was trying with field parameters
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?