The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
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 💡
Proud to be a Super User! | |
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:
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 💡
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.
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 💡
Proud to be a Super User! | |
User | Count |
---|---|
82 | |
81 | |
37 | |
34 | |
32 |
User | Count |
---|---|
96 | |
79 | |
61 | |
51 | |
51 |