Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sofinobi
Helper IV
Helper IV

filter on visual interaction

helllo all,

please, i have two visuals that don't interact correctely, (a bar chart and a matrix), when i clic on the bar chart it doesn't filter on the matrix, it happens only with one measure " Variation CA", if i change the measure it filters correctly
may be the problem is from the measure ?!! 
th Measue calculates the variation of total sales by months: 

Variation CA =
    DIVIDE ( [Vente Net], CALCULATE ( [Vente Net], DATEADD ( CALENDRIER[Date], -1, MONTH ) ), 2 )-1

as in this image, when i clic in the bar chart Seller, i need to filter on the matrix to show only the Clients of that seller.
(the problem is not in the Edit interactions)
variation filter.PNG
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

@Sofinobi 

Indeed. The -1 is creating a problem of forcing all rows to appear regardless of sny filter. That is simply because -1 cannot be filtered and will never be blank. 
Please try

 

Variation CA =
VAR VentNet = [Vente Net]
RETURN
IF (
VentNet <> BLANK (),
DIVIDE (
VenteNet,
CALCULATE ( [Vente Net], DATEADD ( CALENDRIER[Date], -1, MONTH ) ),
2
)
)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

@Sofinobi 

Indeed. The -1 is creating a problem of forcing all rows to appear regardless of sny filter. That is simply because -1 cannot be filtered and will never be blank. 
Please try

 

Variation CA =
VAR VentNet = [Vente Net]
RETURN
IF (
VentNet <> BLANK (),
DIVIDE (
VenteNet,
CALCULATE ( [Vente Net], DATEADD ( CALENDRIER[Date], -1, MONTH ) ),
2
)
)

thank you so much my friend, that works perfectly 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors