Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Stattik_
New Member

Field Parameter not creating graphs properly

I have a Fields parameter that I have made that looks like so: 

Stattik__0-1692387667293.png

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:

Stattik__1-1692387870847.png

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 5
Idrissshatila
Super User
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 👍

Follow me on Linkedin
Vote For my Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




The department is hand inputted in the Field parameter table like so: 

Stattik__0-1692389352475.png

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__1-1692389497818.png

 

@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 👍

Follow me on Linkedin
Vote For my Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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.

@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 👍

Follow me on Linkedin
Vote For my Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.