Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm using two slicers based on Date input, and using two slicers one Year and one Date Range.
My requirement is , when a user enters dates in to date range then, year slicer should be deactived(I mean this filter should be inactive,currently it allows user to select either 2013,2014).
Thanks..
Solved! Go to Solution.
@v-caliao-msft Thanks for the info..
how ever, can I set one slicer more priority than the other..
I mean if there are 2 slicers A&B , when ever some one uses these 2 slicers together, Result should be based on A?
I mean if there are 2 slicers A&B , when ever some one uses these 2 slicers together, Result should be based on A?
There is no a directly option that allow us to achieve this requirement. To work around this, we can use a measure to filter data.
Measure 2 = VAR selectedyear = MAX ( 'Table'[Year] ) VAR selectedmindate = MIN ( 'Table'[Date] ) VAR selectedmaxdate = MAX ( 'Table'[Date] ) RETURN IF ( ( ( ISFILTERED ( 'Table'[Year] ) || ISFILTERED ( 'Table'[Date] ) ) = FALSE () ), 0, IF ( ISFILTERED ( 'Table'[Year] ) = TRUE () && ISFILTERED ( 'Table'[Date] ) = FALSE () && MAX ( Sales[Year] ) = selectedyear, 1, IF ( ISFILTERED ( 'Table'[Year] ) = FALSE () && ISFILTERED ( 'Table'[Date] ) = TRUE () && MAX ( Sales[Date] ) >= selectedmindate && MAX ( Sales[Date] ) <= selectedmaxdate, 1, IF ( ISFILTERED ( 'Table'[Year] ) && ISFILTERED ( 'Table'[Date] ) && MAX ( Sales[Year] ) = selectedyear, 1, 0 ) ) ) )
I have attached the PBIX file, if I select items on two slicers, the result only based on Year slicer.
Regards,
Charlie Liao
You want year un-selectable when enter start date and end date in your range slicer, right? Currently, we can set the interaction between two visual. However, we canno disbale one slicer by another slicer. So I am afraid your requirement cannot be done in current version of Power BI.
Thank you for your understanding.
Regards,
Charlie Liao
Thanks for the reply @v-caliao-msft
how ever, can I set one slicer more prior than the other..
for ex.. I've written a measure Measure1 = Sum(Table1.Price), which can be operated by 2 slicers Date Range and Year.
Can I set a priority, that Measure1 must take Date Range Input first..
If I'm entering date range from "13-Jan-2012" to "13-Jan-2013" , subsequently the year slicer gives option of "2012" or "2013". If we select "2012", so the output will be based on "13-Jan-2012" to "13-Jan-2013" / "13-Jan-2012" to "31-Dec-2012".
Thanks..
If I'm entering date range from "13-Jan-2012" to "13-Jan-2013" , subsequently the year slicer gives option of "2012" or "2013". If we select "2012", so the output will be based on "13-Jan-2012" to "13-Jan-2013" / "13-Jan-2012" to "31-Dec-2012".
Based on test, Power BI will not help you re-select item when you slecte item on another slicer. It will only filter out the items. So I am afirad your requirement cannot be done currently.
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Thank you for your understanding.
Regards,
Charlie Liao
@v-caliao-msft Thanks for the info..
how ever, can I set one slicer more priority than the other..
I mean if there are 2 slicers A&B , when ever some one uses these 2 slicers together, Result should be based on A?
I mean if there are 2 slicers A&B , when ever some one uses these 2 slicers together, Result should be based on A?
There is no a directly option that allow us to achieve this requirement. To work around this, we can use a measure to filter data.
Measure 2 = VAR selectedyear = MAX ( 'Table'[Year] ) VAR selectedmindate = MIN ( 'Table'[Date] ) VAR selectedmaxdate = MAX ( 'Table'[Date] ) RETURN IF ( ( ( ISFILTERED ( 'Table'[Year] ) || ISFILTERED ( 'Table'[Date] ) ) = FALSE () ), 0, IF ( ISFILTERED ( 'Table'[Year] ) = TRUE () && ISFILTERED ( 'Table'[Date] ) = FALSE () && MAX ( Sales[Year] ) = selectedyear, 1, IF ( ISFILTERED ( 'Table'[Year] ) = FALSE () && ISFILTERED ( 'Table'[Date] ) = TRUE () && MAX ( Sales[Date] ) >= selectedmindate && MAX ( Sales[Date] ) <= selectedmaxdate, 1, IF ( ISFILTERED ( 'Table'[Year] ) && ISFILTERED ( 'Table'[Date] ) && MAX ( Sales[Year] ) = selectedyear, 1, 0 ) ) ) )
I have attached the PBIX file, if I select items on two slicers, the result only based on Year slicer.
Regards,
Charlie Liao