cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## Slicers change/interactions

Hello,

How can I make the current and prior date filtered by item selection (apple or grape).

I expect to see the slicers (current, prior) to be changed based on the item selection.

here is example pbix file:

Thank you!

1 ACCEPTED SOLUTION
Super User

Check the file at -https://www.dropbox.com/s/2w80tpj37wkiiz1/Q1.pbix?dl=0

Look at visual level filters and measure used in those and inactive relations.

4 REPLIES 4
Super User

Check the file at -https://www.dropbox.com/s/2w80tpj37wkiiz1/Q1.pbix?dl=0

Look at visual level filters and measure used in those and inactive relations.

Community Support

Hi @topazz11 ,

The file that amitchandak created should work like a charm. I add a blog and a document where you could learn more about active relationship , inactive relationship and how to use them.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

@topazz11, How does the selection of dimension impact date? Try to use time intelligence along Date calendar for standard current prior

``````MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))

Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"12/31"))
This Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD((ENDOFYEAR('Date'[Date])),"12/31"))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
``````
Super User

I could not understand your question. Can you please elaborate? Why You wanted to see the slicers in that why, what should be the outcome

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors