Forum Discussion
Helper IOr Condition on page filter
That makes sense. Yet, I was hoping something that needed fewer manipulations (adding each filter individually is a bit repetitive) but I guess I can do it.
The other solution I found is to create a new column by concatenating FD1 and FD2. Then I added an advanced filter on the page and that requires the concatenated variable to contains "X".
Community ChampionMaxfran You know your data better than me, so I hopefully you're right, but your reasoning is not fully developed, so I am posting this for others and in case your data is not consistent. Underscore will help some, but not in the example I gave, as 707_707 will still CONTAIN 70. So basically you need to carefully consider your values for X and make sure that they none of the possible X values can ever contain another.
For example, setting X value to 7, 7 would be contained in 7, 70 and 700, but you really only want the items that are equal to 7 (so not the 70 and 700).
Is X a number or text? If it's number you could get around this problem by setting the X to text and forcing it to always be exactly the same number of digits.
7 would become 007
70 would become 070
700 would stay 700
Then setting your X value to 007 will never be contained in 070 or 700.
Does that make sense?
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
https://sites.google.com/site/allisonkennedycv
Helper IThanks for this precision.
It 707 contains 70, but not 70_ with an underscore implemented during the concatenation.
So, if I filter to have only "70_", it will be fine.
Actually, my data are text but I had the same issue that you presented with numbers.
- AllisonKennedy
Maxfran of course, sorry I didn't read carefully enough. Genius solution.