User Profile
cmkp2675
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Default Slicer Selection and Trend chart help!!!
Hi v-csrikanth Thank you for your response. But still not working no filters applied except Dropdown SLICER (it's mandatory) to filter other visuals. DAX: LoadDurationLast7Days = CALCULATE( SUM('etl_pipeline_audit'[pipeline_run_duration_mins]), FILTER( ALL('Date_Table'[Date]), 'Date_Table'[Date] >= TODAY() - 7 && 'Date_Table'[Date] <= TODAY() ) )Re: Page-Level Filtering based on the Latest Date
Hi amitchandak Thank You for your response. The issue is if we apply the visual or page level filter it's not responding to the external SLICER. In this case could you please go through the screenshot I attached? In data the there are multiple dates but once the visual level filter or Page level is applied, if we want to see the data of different dates it won't work. That's my biggest issue. Please help me to resolve. LatestDate = CALCULATE(MAX(MetricsData[Date]), ALL(MetricsData)) Column DAX: IsLatest = IF(MetricsData[Date] = [LatestDate], 1, 0) Thank You PradeepRe: Page-Level Filtering based on the Latest Date
Hi v-menakakota, Thank You for your response. The issue is if we apply the visual or page level filter it's not responding to the external SLICER. In this case could you please go through the screenshot I attached? In your data the there are multiple dates but once the visual level filter or Page level is applied if we want to see the data of different dates it won't work. That's my biggest issue. Please help me to resolve. LatestDate = CALCULATE(MAX(MetricsData[Date]), ALL(MetricsData)) Column DAX: IsLatest = IF(MetricsData[Date] = [LatestDate], 1, 0) Thank You Pradeep
