Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
In my reports, i have 2 tables control (Table A and Table B) which contain 2 different datasets. There are also some filter control for each datasets.
Step1: When i choose filters for Table A, Data in Table A is updated base on chosen-filters
Step2: When i choose filters for Table B, data in Table B is updated base on chosen-filters -> BUT data in Table A is refresh without any chosen-filter, it display all data.
Question is: What can i do so data in TableA is not affected when choosing filters for TableB?
Solved! Go to Solution.
@hellgoingon wrote:
Hi,
In my reports, i have 2 tables control (Table A and Table B) which contain 2 different datasets. There are also some filter control for each datasets.
Step1: When i choose filters for Table A, Data in Table A is updated base on chosen-filters
Step2: When i choose filters for Table B, data in Table B is updated base on chosen-filters -> BUT data in Table A is refresh without any chosen-filter, it display all data.
Question is: What can i do so data in TableA is not affected when choosing filters for TableB?
Are you looking for the option "Include in report refresh"? By the way, this option only effect in Power BI desktop. After published to Power BI Service, all queries refresh.
@hellgoingon wrote:
Hi,
In my reports, i have 2 tables control (Table A and Table B) which contain 2 different datasets. There are also some filter control for each datasets.
Step1: When i choose filters for Table A, Data in Table A is updated base on chosen-filters
Step2: When i choose filters for Table B, data in Table B is updated base on chosen-filters -> BUT data in Table A is refresh without any chosen-filter, it display all data.
Question is: What can i do so data in TableA is not affected when choosing filters for TableB?
Are you looking for the option "Include in report refresh"? By the way, this option only effect in Power BI desktop. After published to Power BI Service, all queries refresh.
Yes! Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |