Forum Discussion
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 | 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
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.
9 Replies
NaveenGandhiMemorable Member
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!!!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!!!
