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,
I have this table
Year | Product Code |
2015 | 1 |
2015 | 2 |
2015 | 3 |
2015 | 4 |
2016 | 3 |
2016 | 4 |
2017 | 2 |
2018 | 3 |
2018 | 4 |
I select "2018" from a Year slicer and the "All" from Product Code slicer (selecting 3 & 4)
when I deselect "2018" I would like to keep only 3 & 4 Product Codes, not all 1,2,3,4
is there a way to achieve this? I don't want to manually select 3 & 4, this is for a larger data set, thousands of products.
Thanks
Hi @Tomasjhussey ,
Not sure if I understand your post, but is this what you want?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
No, I DO NOT want to manually select 3 and 4.
I want to select 2018 from year, then select all available codes for 2018, then deselect 2018 and but keep the codes that were selected when I selected all available for 2018
Hi @Tomasjhussey ,
You can write a measure to compare current row content and specific value and return tag, then you can apply it to visual level filter to filter records.
M filter =
IF ( SELECTEDVALUE ( 'Table'[Product Code] ) IN { 3, 4 }, "Y", "N" )
Notice: filter result will changes when you modify in measure formula.
Regards,
Xiaoxin Sheng
Thanks for the response but that's not an ideal solution since it is static.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |