Sunday, August 8, 2021

How to hide filter value without excluding the data from the view?

I have a problem with Filters.

I have a dimension with the values (0, 1, 2, 3, 4, 5). I want to use this dimension as a filter, but not to let the user the option to filter out the value "0". I don't want to exclude the values 0, the opposite - I want these values to ALWAYS be in the view, and let the user the chance to filter only between (1, 2, 3, 4, 5).

Is that an option? To remove a value from the filter, but not from the data?

! 

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/lower case combinations?

  How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/...

  • Real Time Scenario
     1. Color of first and last bar same and other bar same 2. Divide the data into 2 sheets 3. Parameter Month/Quarter then in sheets Year-mont...
  • Filter/ Parameter hide based on Paramter selectoion
    Steps: 1. Create 2 Param1  and Param2. Param1 will be visible all the time the other will appear based on  selection on Param1. 2.Create bla...
  • Calculative field
    1. Some calculations comes under Diemensions and some under Measures 2. Some calculation we can change from Dimension to Measures and vice v...