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.
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
Solved! Go to Solution.
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
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
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |