Portland Power Platform User Group

I have built a bar graph (stacked) which provides me with the % breakdown of employees who have completed a background check by division.
Leadership would like to only reflect the % of those who have failed the background check by division.
Looking for help with a measure/etc. that would show that in one area failed is 2.64% and not 80.53% when I use a filter.

Many thanks!!!
Jennifer

------------------------------
Jennifer Lucas
HRIS Analyst
jlucas@schn.com
------------------------------

Hi Jennifer,

Can you send a screen capture of your model and a simplified example of source data /visuals so as to help you build the measure ?

------------------------------
Vincent L.
Chartered accountant - Expert-comptable
------------------------------

Original Message:
Sent: Jun 10, 2020 11:45 AM
From: Jennifer Lucas
Subject: Bar chart Drill Down % question

I have built a bar graph (stacked) which provides me with the % breakdown of employees who have completed a background check by division.
Leadership would like to only reflect the % of those who have failed the background check by division.
Looking for help with a measure/etc. that would show that in one area failed is 2.64% and not 80.53% when I use a filter.

Many thanks!!!
Jennifer

------------------------------
Jennifer Lucas
HRIS Analyst
jlucas@schn.com
------------------------------

Hi Vincent -

Thank you for reaching out and I was able to meeting with Rachael from the group and she was able to help me.
Be on the look out as I will most likely have additional questions in the future. :-)

Jennifer​

------------------------------
Jennifer Lucas
HRIS Analyst
5034157875
------------------------------

Original Message:
Sent: Jun 10, 2020 01:58 PM
From: Vincent L.
Subject: Bar chart Drill Down % question

Hi Jennifer,

Can you send a screen capture of your model and a simplified example of source data /visuals so as to help you build the measure ?

------------------------------
Vincent L.
Chartered accountant - Expert-comptable

Original Message:
Sent: Jun 10, 2020 11:45 AM
From: Jennifer Lucas
Subject: Bar chart Drill Down % question

I have built a bar graph (stacked) which provides me with the % breakdown of employees who have completed a background check by division.
Leadership would like to only reflect the % of those who have failed the background check by division.
Looking for help with a measure/etc. that would show that in one area failed is 2.64% and not 80.53% when I use a filter.

Many thanks!!!
Jennifer

------------------------------
Jennifer Lucas
HRIS Analyst
jlucas@schn.com
------------------------------

Woohoo :) happy you got it figured out!

------------------------------
------------------------------
Bastian Dufosse
Consultant
CSG Pro
Portland OR
bastiand@csgpro.com
------------------------------
------------------------------

Original Message:
Sent: Jun 10, 2020 06:35 PM
From: Jennifer Lucas
Subject: Bar chart Drill Down % question

Hi Vincent -

Thank you for reaching out and I was able to meeting with Rachael from the group and she was able to help me.
Be on the look out as I will most likely have additional questions in the future. :-)

Jennifer​

------------------------------
Jennifer Lucas
HRIS Analyst
5034157875

Original Message:
Sent: Jun 10, 2020 01:58 PM
From: Vincent L.
Subject: Bar chart Drill Down % question

Hi Jennifer,

Can you send a screen capture of your model and a simplified example of source data /visuals so as to help you build the measure ?

------------------------------
Vincent L.
Chartered accountant - Expert-comptable

Original Message:
Sent: Jun 10, 2020 11:45 AM
From: Jennifer Lucas
Subject: Bar chart Drill Down % question

I have built a bar graph (stacked) which provides me with the % breakdown of employees who have completed a background check by division.
Leadership would like to only reflect the % of those who have failed the background check by division.
Looking for help with a measure/etc. that would show that in one area failed is 2.64% and not 80.53% when I use a filter.

Many thanks!!!
Jennifer

------------------------------
Jennifer Lucas
HRIS Analyst
jlucas@schn.com
------------------------------