Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a calendar table with two columns: one is for dates, the other is a "Enabled" flag (1 to enable, 0 otherwise).
I want to use da date column as a numeric range slicer (between filter) and filter the single slicer visual for rows that has the "Enabled" flag to 1.
As an example, I used the very same dates as the values of a table to test the slicer.
The slicer works fine until I don't filter it with the "Enable" value, then, it seem to have filtered the slicer correctly (the dates displayed change accordingly) but the filtering action of the slicer on the table isn't affected: the dates are all still visible. If instead of the last value I move the slicer to the penultimate date, then it works!
It seem that when the range slicer is set to the last position it will in fact select the last available value regardless of the visual filter.
It seem also strange to me that if I turn the slicer to the "Dropdown" mode, when Date are filtered by "Enable" and I "Select All" the data, it will ignore the visual filter.
Is this some kind of bug or is it intended behaviour? What's your take?
Thank to anybody that will take time on this.
Best,
Cesare
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.