Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am having two different SSAS tabular models so there are 2 tabular models. I want to create a dashboard with reports from both the tabular models. both the models contains Customer as one of the dimension. I have created one report from model1 and another report from model2 and then want to create a dashboard using both the reports i.e. reprot1 and report2.
Now my requirement here is, I want to show only one Filter i.e. Customer and If I select this filter then, it should apply to both the reports. so if user select Customer from filter then data should filter for both the reports from dashboard.
Is there any way to achieve this. I cannot create single model so that is my limitation.
Hi aniruddha20,
Report level filter can meet your requirement, please refer to: https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter#add-a-filter-to-an-entire-repor...
Regards,
Jimmy Tao
Thanks for your reply but I do not see anything in the document which specifically answer my question on Filters. I see only how to set filters but in my case I want to create a single FILTER for slicing data from two different datasets
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |