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,
Please help me with the below requirement.
I have two table views of the same data set. However, one table should work with a page filter, and another table should show all the data. Trying to figure All Expect measure but no luck.
Note: I am using Power BI Data Set as my source. So I cant create multiple tables, I cant create columns.
Dataset:
Phones | Category |
Iphone6 | No Demand |
Iphone7 | Demand |
Iphone8 | Demand |
Iphone9 | No Demand |
Iphone10 | Demand |
Iphone11 | Demand |
Result:
I cant. The page-level filter is my global filter which impacts 20 pages visualizations.
The other way I was thinking is use Filter on current Page for the other 19 pages, and use Filter on Visual for the page you are working on.
I don't know if there is another way.
I used the column on "Filters on this page" on all 19 pages and for this requirement, I have used "Filter on this Visual". But this is not a smart way of development. Thanks for the response.
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.