Dynamic Slicer – Show Fiscal Year for INR Country and Calendar Year for Others
Hi Experts, I have a requirement to dynamically customize my date slicer based on country selection. Scenario: If the user selects INR (India) as the Country → The slicer should display Fiscal Year (Apr–Mar). If the user selects any other country → The slicer should display Normal Calendar Year (Jan–Dec).
Filtering from slicer and OR logic in DAX is not able to achieve in my case
Hi All, Data Validation : I am using 2 slicers (Amount in usd & churn in usd) with min & max values and few cards to display the counts based on the selected slicer values as below : below the query which is executed from snowflake data source and the expected result is 490 , but i am getting 447 with all the filters applied in this query (using slicers in power bi report) Snowflake query : Output - 490 row count select * from datalake.dm_bss_oss.vw_opportunity_quote_source where sales_involvment='Sales Opportunities' and opportunity_stage='Closed Won' and closed_date between '2025-01-01'and'2025-06-30' and (amount_in_usd between '0' and '50000' or churn_in_usd between '-50000' and '0'); -- values 0,50000 and all are just a sample in this query but we have a separate slicers for the amount seelction in dashboard DAX query : Output - 447 row count (should be 490) CALCULATE (COUNT('Opportunity Quote Source'[SFDC_ENSONO_OPPORTUNITY]), FILTER (ALLSELECTED('Opportunity Quote Source'), ( 'Opportunity Quote Source'[AMOUNT_IN_USD] >= MIN('Opportunity Quote Source'[AMOUNT_IN_USD]) && 'Opportunity Quote Source'[AMOUNT_IN_USD] <= MAX('Opportunity Quote Source'[AMOUNT_IN_USD]) ) || ( 'Opportunity Quote Source'[CHURN_IN_USD] >= MIN('Opportunity Quote Source'[CHURN_IN_USD]) && 'Opportunity Quote Source'[CHURN_IN_USD] <= MAX('Opportunity Quote Source'[CHURN_IN_USD]) )))
