Forum Discussion

Anonymous

Not applicable

2 years ago

one page filter for two different dates

I have 2 visualisations on the same page. these visualisations are based on 2 different tables / each visualisation is based on its own, specific table. both visualisations contain a date field/co...

Solution Sage

2 years ago

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?

Anonymous
Not applicable
2 years ago
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....
- Kaviraj11
  Solution Sage
  2 years ago
  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 !!
  - Anonymous
    Not applicable
    2 years ago
    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?