Forum Discussion
Slicing by state
rdurrell
Add the state field from parameter into matrix column. Also please replicate the measure "ADJ" from my file[Alter it as per your field names] and use in matrix values.
Memorable MemberHi rdurrell
Thanks for your question, Can you share sample file and sample output to understand the problem better.
Try to add screenshots of the errors and results that you see as well.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
Sure.
When I click my slicer, nothing happens. What is my issue? I have relationships between my slicer and the columns. Each column value is associated with a state as in my example data table above, but I cannot slice by state.
- NaveenGandhi
rdurrell
Slicer filters on each row line level and not on column level, I..e you can add year as a slicer and select year 1 to see year 1 data for CT, MA, NH.
I have attached a POC PBIX which might be helpful for you. I have used field parameter and a measure to achieve this.
Let me know if this is what you are looking for.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!So what you did was you created a new table with:
[State Parameter ] = {("CT", NAMEOF('CT'[State]), 0),("NY", NAMEOF('NY'[State]), 1)}And then created a field parameter?- NaveenGandhi
rdurrell
When you create field parameter the table is automatically created.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!