Forum Discussion
one page filter for two different dates
Hi,
For 1st Problem, you will need to unselect the hierarchy date. Select the highlighted one.
I have a trouble understanding the second question. Could you share an example or a pbix file?
For 1st problem, I unselected the 'hierarchy date'-option by selecting the 'date'-option.
still, my table contains values / records for every day.
I want the user to only see a few years and corresponding quarters and months in the filter.
not every day / not all the days in the month....
Create this measure:
SlicerFilter = INT ( NOT ISEMPTY ( 'Table Name' ) )
and drag it to the filter pane and give condition as 1
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
in which table do i create this measure? or is that not important?
for which table / which table do i specifiy in the isempty function?
i created this measure in a genericTable and specifiek the filtertable in the isempty function and dragged it to the filter pane and gave condition as 1. nothing happened.....
why do you suggest to check if the table is not empty?
Hi,
Thanks for the solution Kaviraj11 offered and i want ot offer some more information for user to refer to.
hello Anonymous , based on your descriotion, you can put the year column, month column and quarter column to the page filter. and you only need to create the 1:n relationship(calendar date and other dates column in two tables).
Output
Or you can create three slicers, put the year , quarter, month to the slicers.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.