Forum Discussion

Will0909's avatar
Will0909
New Member
1 year ago
Solved

Filtering

Hi all, I hava one data set from semantic model, where I planned to create a line & clustered column chart. The chart will show the trend of specific Financial Account, ie: Line chart will show exp...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Will0909 

    The issue you’re encountering with the filters integrating despite using two tables from the same semantic model is likely due to the underlying data relationships and how the semantic model handles them.

    I create sample tables:

     

    Then create two different visuals, and put fields in it

    Select the Account field in the Expenses table and drag it to the filter area of the report page. Repeat the steps above to drag the Account field from the Sales table to the filter area.

     

    When I select the Account from Expenses table, the other visual not change:

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.