Slicing by state

[rdurrell]

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	CT
3	300	CT

I have multiple queries for each different state, but all of them are grouped in by state. For example, the above data is for CT, and I may have another one that is for NY, etc.

Whenever I try adding a slicer, it does not work. I have created a seperate index with all of my states and linked them to each query, but it still does not work. What am I doing wrong?

Thanks

[NaveenGandhi]

Hi @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!!!

[rdurrell]

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!!!

[rdurrell]

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!!!

[rdurrell]

I am confused. What was your first step? Creating a field parameter? With which fields?

[NaveenGandhi]

@rdurrell 

Try creating a field parameter using all the fields you want to include.

[rdurrell]

I have done that now, but it still won't filter. When I click on "CT" for example nothing happens. Is there another step?

[NaveenGandhi · Accepted solution]

@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.