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

Get 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

Reply
Anonymous
Not applicable

Chart Not Filtering Properly

Hi,

 

I am new to PBI and seek some guidance.

Please refer to the data model below.

 

 Model.PNG

Note that I had to create a bridge table called EmployeeEmail to join PBI_Event and Employee because otherwise it's Many to Many relationship.

 

I would like to analyze number of days from today each user/employee was last active.

For this, I created two measures:

 

LastActivity = CALCULATE(MAX(PBI_Event[CreatedDateUtc+10 - Date]))

InactivePeriodDays = VALUE(CALCULATE(TODAY() - [LastActivity]))

Then, using this measure in stacked bar char as per below.

chart.PNG

 

It seems to be working OK, but when I tried to filter the chart to only include active employee using [Employee].[EmployeeStatus] in the Visual Level Filter, the chart generates wrong data (see below).

 

chart2.PNG

 

Similarly, if I put EmailAddress in Visual level filter, and just choose an email address, it does not filter the chart to only show that user, so looks like the filtering does not work properly.

 

I am not sure why this occurs. Is it in the measure calculations and/or the data model relationship or something else that I miss?

 

Any advice is appreaciated.

 

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

Drag measure [LastActivity] to visual level filter and set Show items when the value is not blank.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

Drag measure [LastActivity] to visual level filter and set Show items when the value is not blank.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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