Forum Discussion
Helper IVFields Parameter error when to display selected date column
Hi ...
I try to use Fields Parameter to display selected columns for reporting purposes.
I am able to create the slicer but when I try to create the table by using the parameter created, I receive an error as below:
After my investigation, I discovered the error occurred because of the date column. If I remove it, I can display the output.
I tested it at another table, and the data can only be displayed if I select as First as shown below:
How can I resolve it .... Please help me ....
Regards,
NickzNickz
NickzNickz , this means the date column you are using does not have any relation with measure/value column.
Please check relationship
Also, make sure field parameters are used in the correct place
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
1 Reply
- amitchandak
Super User
NickzNickz , this means the date column you are using does not have any relation with measure/value column.
Please check relationship
Also, make sure field parameters are used in the correct place
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f