Forum Discussion
Multiple slicer question/ dataset format question
Hello there, pretty new to this POWER BI thing and ran into a little trouble while putting toether a report. As the picture above shows, i want to have multi level filters that will allo...
v-jiascu-msft
Microsoft Employee
Microsoft Employee
Hey, I am actually using slicers. The issue I have is that, in you example you slice by names and year and I assume that each city and year has one sale price attached to it. My issue is that each city has three values under each year, so I'm not sure how to set up my data table in a way that it will allow me to slice by city and again to Alice by year in which the chart would then show the 3 values that corespond to the selected city and year.
- v-jiascu-msft