Forum Discussion

rdurrell's avatar
rdurrell
Frequent Visitor
2 years ago
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 ...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    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.

     

NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
2 years ago

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's avatar
rdurrell
Frequent Visitor
2 years ago

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?