Forum Discussion
PowerBI - dynamic y column filtering
Hello,
I am currently tried to build a dynamic visual where you can filter by month, location and between multiple y columns
Essentially I'd like users to be able to select a month, location and then select a factor to view, i.e. Month, A, and Factor 3 and for the visual to update accordingly. I have tried field parameters but I can't quite get it to work as it groups the data based on the numeric values.
Any ideas? Thanks in advance
Example data set:
| Month | Location | Factor 1 | Factor 2 | Factor 3 | Factor 4 |
| June | A | 2 | 3 | 2 | 4 |
| July | B | 1 | 6 | 2 | 7 |
| August | C | 4 | 4 | 4 | 6 |
Hello ICush ,
Okay do the following, create a measure for each factor column that sums it and then group them in a field parameter then try to display it, It should work like that.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
9 Replies
- Idrissshatila
Super User
Hello ICush ,
You could set this using field parameters.
check it out https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡Hello,
Thanks for answering, I have tried using that and keep getting stuck. Do you have a recommendation on how to build a column chart using a field parameter (containing factor 1, factor 2, factor 3, factor 4) - what would go on the y-axis?
Thanks!
- Idrissshatila
Hello ICush ,
you group these factors in a field parameter, and youadd the value of the field parameter to the y-axis.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡Hello,
Thanks again, I've grouped the factors in a parameter, added it the y-axis, and whatever I put in the x-axis doesn't bring up anything in the visual. What would recommend putting in the x-axis if the parameter is in the y-axis? I think I must be missing something.
- Idrissshatila
Hello ICush ,
do you have a relationship between the tables having the values in x-axis and table having the factors ?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
