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.
I want to create a table/chart of all stores with revenue>1mUSD per Year. In addition I want to include the product names as further drill down option. It is possible in excel to select at what level I want to apply the numeric filter (here the store names), however in Power BI the numeric filter gets applied to the lowest level (which is the product names) and selects only the product with revenuw >1mUSD. Is there a fix available to select the level of aggregation (i.e., at a store level and not products)?
Solved! Go to Solution.
Hi @mpaukee,
You could create measures to determine which level is based on to aggregate numeric values. You can sum values based on store level or product level. But, for the requirement that conditionally select the level of aggregation is not supported now.
Best regards,
Yuliana Gu
Hi @mpaukee,
You could create measures to determine which level is based on to aggregate numeric values. You can sum values based on store level or product level. But, for the requirement that conditionally select the level of aggregation is not supported now.
Best regards,
Yuliana Gu
@mpaukee you will need to agregate the data first i would think with a summarize statement into a new table and then apply the filter
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |