March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a report where the top left visual is based on a filter called Periods -1, so it always selects our last period by site.
The bottom line chart is based on the filter where this is in current fiscal year = True.. So I get the full YTD.
When I click on the top left to select a site the bottom visual then only shows the filter "periods from today -1 "
When editing interactions I only have Filter or No Filter Option...
Is what I am trying possible or do have to use a slicer, I have been trying to keep the reports clean rather than having to change stuff on a slicer...
Cheers#
Andy
Solved! Go to Solution.
Hi @Kaviraj11 , @farmdev ,thank you for your quick replies, I'll add more.
Hi @Spudduk ,
Regarding your question, create measures to populate the visual objects at your bottom.
The Table data is shown below:
1.Suppose the only filter I need to pass is the field 'Type'
2.Creating DAX Expressions with ALL Functions(Removed the filtering effect of the field 'Date')
ALL function (DAX) - DAX | Microsoft Learn
Measure = CALCULATE(SUM('Table'[Amount]),ALL('Table'[Date]))
3.Final output
Thanks , but I have used the edit interactions and it is that I cannot get working, every time I click on the site bar in the top left , it acting as if it also sending across the "Periods from Today = -1" filter to the bottom filter. When all I want is the "SITE" filter and leave the date range as Year To Date... Attached are the visual filters for the tope left and bottom visual....
Hi @Kaviraj11 , @farmdev ,thank you for your quick replies, I'll add more.
Hi @Spudduk ,
Regarding your question, create measures to populate the visual objects at your bottom.
The Table data is shown below:
1.Suppose the only filter I need to pass is the field 'Type'
2.Creating DAX Expressions with ALL Functions(Removed the filtering effect of the field 'Date')
ALL function (DAX) - DAX | Microsoft Learn
Measure = CALCULATE(SUM('Table'[Amount]),ALL('Table'[Date]))
3.Final output
Quick suggestion:
When editing interactions, do you have the bar graph selected before changing the other interaction?
When I first started using the interaction editor sometimes the wrong visual was highlighted.
Hi, are you trying to keep the line chart as it is even user interact with other visuals? If Yes, then using 'Edit Interaction', you can disable th interation to the other visuals.
Let me know if it's not clear
Change how visuals interact in a report - Power BI | Microsoft Learn
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
96 | |
82 | |
69 | |
61 |
User | Count |
---|---|
138 | |
115 | |
115 | |
99 | |
98 |