Forum Discussion
Field Parameter not creating graphs properly
I have a Fields parameter that I have made that looks like so:
With "Main Data" X-axis being Data and Y-Axis being each of the parameter. The main use is to be able to filter by 2 things at once, For example, I want to see all the corporal data on a time graph, etc.
Now I need to expand its use and am trying to create a Bar Graph in which:
X-Axis: Department
Y-Axis: The Parameter
However the output looks like this:
However as you can see, all the data show up at all the columns. Im not sure why this doesn't work as expected. I want to see only corporal data in the corporal column and so on. Does anyone know a fix or work-around to this?
5 Replies
- Idrissshatila
Super User
Hello Stattik_ ,
So the issue is that there's a missing relationship between the tables that you're getting the department from and the table you're getting the values in the parameter from.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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:
- Idrissshatila
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 👍
