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.
Purpose/Why:
We have datasets sharing a date dimension (Year specifically) and not all datasets span the entire year set. Thus on some pages I'm filtering the year selector down so that only valid options can be selected using a 'between' numeric slicer.
However when the numeric slicer is set to either limit, it removes the filtering completely. e.g. if we have years 2000 - 2010 and this dataset only does 2001-2008 then when the slicer is set to it's upper limit of 2008 all years above that show:
If you move away from the limit then the filtering kicks in. This is incredibly unintuative which is why I'm calling this a bug.
Can't see how to insert a pbix file to demo, however it's incredily simple to reproduce - create a range, add a column to filter on (to reduce set), filter slicer, have a table with min & max, and play with slicer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.