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.
Hello
I have columns like WareHouse, Plant, Storage Type, Storage Bin in one table and i built report on top of this table with a slicer on warehouse.
.
The filtering requirement is as below -
If warehouse selected is not null, then Storage type should be filtered to 100
If warehouse is null, then no filtering on storage type and should get records for all storage types.
How can I achieve this. Any ideas pls.
Solved! Go to Solution.
I created a flag with the logic I need. then added that flag to the report level filters. It worked.
I created a flag with the logic I need. then added that flag to the report level filters. It worked.
@Anonymous wrote:
Hello
I have columns like WareHouse, Plant, Storage Type, Storage Bin in one table and i built report on top of this table with a slicer on warehouse.
.
The filtering requirement is as below -
If warehouse selected is not null, then Storage type should be filtered to 100
If warehouse is null, then no filtering on storage type and should get records for all storage types.
How can I achieve this. Any ideas pls.
@Anonymous
Could you post any sample data? It sounds that you can achieve the goal with some tricky measure composed with ISFILTED, ALLEXCEPT etc.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |