Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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.
@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:
@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!!!
I am confused. What was your first step? Creating a field parameter? With which fields?
I have done that now, but it still won't filter. When I click on "CT" for example nothing happens. Is there another step?
@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.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
179 | |
86 | |
69 | |
63 | |
55 |