Forum Discussion
Help with filters
Good afternoon. I have a small problem and a challenge for some of you.
I have 2 tables, "Calendar" and "Table1". Within the table calendar I have a column formulated with a range of dates and its corresponding parameter, that parameter is that I have applied as a double filter, which I could not do and is where I need your knowledge, is it in the FILTER1 selected 2P February, therefore FILTER2, should only show 2P February onwards .. that is, it will not show 1P January or 2P January .. I hope someone can support me, since I do not give with the answer.
and the sum of the salary corresponds to the period selected in the filter
Greetings to all and thanks for your help.
add example:
https://drive.google.com/open?id=14VHXOJx78XmeWuEyUxcq5qhHePcQt98m
Hi Anonymous,
First, text column is impossible to use slicer to achieve 'before' or 'after' filter mode. I'd like to suggest you to use date value or numeric value to instead.
Second, power bi use 'and logic' to link slicers, if you have multiple slicers with same source column, it is impossible to get different selection items from different slicers.
AFAIK, you can use measure as filter tag to control which item displayed in visual. Unfortunately, it not works on slicer. (visual level filter of slicer is been disabled,if you apply on page level, it will also affect other visuals)
Regards,
Xiaoxin Sheng
2 Replies
Hi Anonymous,
First, text column is impossible to use slicer to achieve 'before' or 'after' filter mode. I'd like to suggest you to use date value or numeric value to instead.
Second, power bi use 'and logic' to link slicers, if you have multiple slicers with same source column, it is impossible to get different selection items from different slicers.
AFAIK, you can use measure as filter tag to control which item displayed in visual. Unfortunately, it not works on slicer. (visual level filter of slicer is been disabled,if you apply on page level, it will also affect other visuals)
Regards,
Xiaoxin Sheng