Visual filter not working for date field slicer when using Before, After, or Between?
I have a measure that just checks if the slicer above isfiltered (Is Terminated) and returns 1/0 You can see there appears to be no values when I am using the Between setting If I change the slicer to dropdown, the values show up.
Measure as Gauge visual filter
Hi, For our sales dep. I'm working on a report in which we compare the signed and expected (hot) deals against the target. The idea is to have slicers in place to select the status of a deal (for example, "signed, won") and to select if the deal is a hot deal or not. If the hot deal slicer is set to "yes", then the result set should show the deals with the selected statusses + all deals with hot deal = yes (regardless the status). So the slicers combined must use "OR" logic instead of the default "AND" logic. I'm trying to visualize the results (from table Query1) in a radial gauge visual. To make this work I created 2 unlinked tables with the statuses and the hot deal boolean and a measure "FilterMeasure" with the following DAX: FilterMeasure = CALCULATE((MAX(Query1[Status]) = SELECTEDVALUE(StatusTable[Status])) + (MAX(Query1[HotDeal]) = SELECTEDVALUE(HotDealTable[Value]))) The idea is to create slicers for the 2 unlinked tables and to add the measure as a visual filter with expression > 0. The problem is that this approach isn't working for the Gauge visual. I can add the measure as a visual filter to the gauge, but I'm unable to set the parameters: Using the measure as a visual filter on a table is working: For sure the DAX command isn't correct, but I don't know how to write the DAX for the measure so that it can be used as a visual filter on a gauge visual. Or maybe the a complete different approach to achieve the goal to append records to the result set without considering the selected slicer value. Hope someone can help me out.show date if falling between a start and an end date.
I have a data set with a few thousand line items. In this, there are 2 columns, a start date, and an end date. I am looking for a way to determine if an item was standing during a certain date. This is easy to do with a simple if statement, but the problem Im having is that I want to be able to filter it at the visual level by any date, selected by the user. I have [ActualBuildDate] and [ActualDismantleDate] Where [ActualBuildDate] will aways have a date, and [ActualDismantleDate] will alway be after [ActualBuildDate] or blank (Still standing). If I select January 2020, I want to see every item that was standing during January 2020. I have a Calender table set up using this code Date Filter = DATESBETWEEN( 'Date'[Date], MIN('1_Overview'[ActualBuildDate]), IF(MAX('1_Overview'[ActualDismantleDate]) > MAX('1_Overview'[ActualBuildDate]), MAX('1_Overview'[ActualDismantleDate]), MAX('1_Overview'[ActualBuildDate]) )) I have set a filter with a date heiarchy using this. but filtering by the dates on it do not return the proper items.
