Forum Discussion
Tables of data
Hi Sun1，
Based on your description, you want to filter all the fields(column hearder in Trust Level table). We are unable to achieve it, because the slicer is used to filter the row records in the table rather than columns. Thanks for understanding.Best Regards,
Angelia
Microsoft EmployeeHi Sun1,
For Trust Level, create a slicer, which field should added? By another way, like the choose in the web, what value should be as the options? Please describe clearly. Thanks a lot.
Best Regards,
Angelia
Hi Angelia,
The Year and Level would be slicers that a user would select. If I was to select 2003/2004 and then select Trust Level I would like the table to appear with all fields. The website shows another dropdown, 'Section', but in my case I only want to change between Trust Level data and Site Level data. In terms of how to do this and to see if it's possible, I'm unsure.
I hope that explains it. Sorry I can't explain it further.
Sun1
- v-huizhn-msft
Hi Sun1，
Based on your description, you want to filter all the fields(column hearder in Trust Level table). We are unable to achieve it, because the slicer is used to filter the row records in the table rather than columns. Thanks for understanding.Best Regards,
AngeliaCheers for that Angelia, I was wondering whether it was possible or not. I may try think of some alternatives. But thanks again for your advice.
Sun1