Forum Discussion
Field Parameter not creating graphs properly
The department is hand inputted in the Field parameter table like so:
The thing is a slicer works properly, if I choose the slicer to be "Corporate" than only value with Department label Corporate will show up. What workaround or alternative would you suggest? The values in the parameter can't really be linked with a relationship due to how it's formatted as shown here:
Stattik_ ,
Where are you getting the department column, from which table ?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- Stattik_3 years agoNew Member
The department column is hand made. I inputted what each parameter's departments are in PowerBI as shown in the DAX code for the parameter. The main data does not distinguish each value by its department which is why this field parameter is made.
- Idrissshatila3 years ago
Super User
Stattik_ ,
so the issue is that the department is not related to the values in the main data, whoch means that in the main data table there's no value that tells that this record is related to this department.
there should be a department column on the data table that tells each record is for a specific department.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍