cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oolamide85 Frequent Visitor
Frequent Visitor

Visual Level Filter

I have visualisation show workers by weekly hours, but I want my visual to display on worker with more than 72Hrs per week.

 

Please see attached and am getting my sum of hours from column worked_Hours.Visual.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-cherch-msft Super Contributor
Super Contributor

Re: Visual Level Filter

Hi @oolamide85

 

Try again this.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
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

5 REPLIES 5
v-cherch-msft Super Contributor
Super Contributor

Re: Visual Level Filter

Hi @oolamide85

 

You may try to create a measure like below to get the visual as requested.

Measure  =
VAR workhours =
    CALCULATE ( SUM ( Table4[worked hours] ) )
RETURN
    IF ( workhours >= 72, workhours )

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
oolamide85 Frequent Visitor
Frequent Visitor

Re: Visual Level Filter

The Column workhours are daily worked hours and I have the sum of worked hours in week in report view which is fine, but I want the report to show only worked who have worked more than 72hrs . 

v-cherch-msft Super Contributor
Super Contributor

Re: Visual Level Filter

Hi @oolamide85

 

Here is the sample file. If it is not your case, please share your data sample file. You can upload it to OneDrive or Dropbox and post the link here.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
oolamide85 Frequent Visitor
Frequent Visitor

Re: Visual Level Filter

unable to download the file.

 

Thanks.

v-cherch-msft Super Contributor
Super Contributor

Re: Visual Level Filter

Hi @oolamide85

 

Try again this.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 897 guests
Please welcome our newest community members: