Forum Discussion
Solved
Slicing by state
Hello. I have some data in many different queries for different adjustments I make to a forecast by year. For example, I have data such as this: Year Adjustment State 1 100 CT 2 200 ...
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.
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
Memorable Member
Memorable Memberrdurrell
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!!!
I am confused. What was your first step? Creating a field parameter? With which fields?
- NaveenGandhi
I have done that now, but it still won't filter. When I click on "CT" for example nothing happens. Is there another step?