Show fields used in filters

[JBST]

Good morning

Am working through fixing a report for someone and was wondering if there is the ability to show which version of a field has been used in a page level filter.

There are in excess of 30 different fields called 'Contract' in the analysis services model provided and one of these has been included in the report level filters but this given field is held in every dimension need to determine which one is being used in the filter.

Given there is no ability to create a model in this instance  (only have report ability on left hand side)  was hoping there was an easy way to determine which dimension the field is linked to in the same way you see the chosen fields for visuals highlighted with a yellow tick.

Thanks

[XLBob · Accepted solution]

when you hover over the fields in question in the fields pane in PBI desktop, it should tell you which dimension table it's coming from

[JBST]

Thanks - hover in the right spot and seems so logical when someone points it out to you 

Have a great day 🙂