Forum Discussion
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 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
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.
3 Replies
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
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.
