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 have a table with some sales, like the following:
Id_Product | Product | Group | Subgroup | Value_Sold | Date_Sold |
1 | Computer | Eletronics | IT | 1000 | 2018-05-01 |
1 | Computer | Eletronics | IT | 1000 | 2017-06-01 |
1 | Computer | Eletronics | IT | 1000 | 2017-07-01 |
2 | Mouse | Eletronics | Peripherals | 25 | 2018-05-01 |
2 | Mouse | Eletronics | Peripherals | 25 | 2018-06-01 |
3 | Headphone | Eletronics | Sound | 35 | 2018-12-01 |
I need to make a entire page that suffer the inverse action of slicer.
On my table I have sales on May/June/July and December and on 2017 and 2018.
If the user selects DECEMBER/2018 for example, my entire page should show only sales that NOT HAPPENED on DECEMBER, something like the inverse filter.
The user select a month and the page shows values different than selected value.
By the way, my page has a table and I show wich product not sold on selected date, I cannot show only SUM of Value_Sold, I need show the products with their own group, subgroup and name.
Is it possible?
Solved! Go to Solution.
I built one of those once:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266
OK, I was able to accomplish it. So, what you need is a Separate table for your dates like:
Table = DISTINCT('Table'[Date_Sold])
Relate that to your main table. Create a slicer based upon this new table but Edit Interactions such that it does not interact with your table. Now, create a Measure like:
Measure 2 = VAR __selected = MAX(Table8[Date_Sold]) VAR __current = MAX(Table7[Date_Sold]) VAR __yearSelected = YEAR(__selected) VAR __monthSelected = MONTH(__selected) VAR __yearCurrent = YEAR(__current) VAR __monhtCurrent = MONTH(__current) RETURN IF(__yearCurrent = __yearSelected && __monhtCurrent = __monthSelected,0,1)
Now, filter on that for Greater than 0.
See Page 4, Tables 7 and 8 of attached.
I built one of those once:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |