Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
65 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
85 | |
75 | |
56 | |
50 | |
45 |