Filtering

[Will0909]

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 expense amount and bar chart will show sales amount. Within this chart I also create a 2 filtering boxes therefore user could easily change the account (bar chart & line chart) based on the needs.

As far as I know, 2 filtering will integrated with each other if the source table are the same. Therefore I tried to create 2 table by getting the data from the same semantic model two times, in example: Table-1 (Semantic Source: "Raw Data") and Table-2 (Semantic Source: "Raw Data").

Eventhough, I tried to crate 2 table the filter still integrated with each other.  

I really appreciate any ideas or insight regarding my problem.

Cheers,

Will

[v-yohua-msft · Accepted solution]

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.

[Uzi2019]

Hi @Will0909 

Share some screenshot and randon data. create everything in excel and take screenshot from excel n paste it here so that your scenario will be more understandable.

[Ritaf1983]

Hi @Will0909 

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly