I have a data model with a fact table and several dimension tables connected to the fact table.
If I have slicers in my worksheet, how can I determine if those slicers were created off the fact table column or the dimension table column?
For instance, if my fact table has a column Periods (Jan 2016, Feb 2016, etc.) and that is related to my DateTable field Periods... and then I have a slicer, but I don't recall which table it was created off of. I'd like to know if there is a way to determine this.
Thanks
If I have slicers in my worksheet, how can I determine if those slicers were created off the fact table column or the dimension table column?
For instance, if my fact table has a column Periods (Jan 2016, Feb 2016, etc.) and that is related to my DateTable field Periods... and then I have a slicer, but I don't recall which table it was created off of. I'd like to know if there is a way to determine this.
Thanks