Advice Please Variation Visual

[Anonymous]

I need some advice.

I have a dataset similar to this;

Staff_Name	Start_date	Leave_date
Person A	02/01/2020	12/01/2020
Person B	03/01/2020	12/01/2020
Person C	12/12/2019	03/01/2020
Person D	12/11/2019	04/01/2020
Person E	05/01/2020

WHat I am looking for is a visual that I can use to then show the new starters above a line and the leavers below a line to visually show whether we have more leavers than starters for example.

Any help appreciated.

Thanks Jack

[Ashish_Mathur]

Hi,

Why do you want to show leavers below the line.  Why not build a simple column chart with Year and Month on the X-axis and 2 bars - one for joiners and another for attrited employees?

[v-yingjl]

Hi @Anonymous ,

Based on my research, I have found three visuals try to meet your requirements: 'Tornado chart', 'Gauge' and 'Muti-row card'

I have created a calculated column to mark whether someone has left and three measures to calculate the starters, leavers and totals

Leave? =
IF ( 'Table'[Leave_date] <> BLANK (), 1, 0 )

Starter =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Leave_date] = BLANK () )

Leaver =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Leave_date] <> BLANK () )

Total = COUNTROWS('Table')

1. Tornado chart

2. Gauge

3. Muti-row card

Here is the sample .pbix file that you can refer: Advice Please Variation Visual.pbix 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-yingjl ,

I am getting an error with this column.

Starter =

CALCULATE ( COUNTROWS ( employee_profiles ), employee_profiles[leaver_notifications.leave_date] = BLANK () )

The error is;

A circular dependency was detected: employee_profiles[Column], employee_profiles[Leaver], employee_profiles[Column].

[v-yingjl]

Hi @Anonymous ,

In my sample file, the only the 'Leave?' is a calculated column, ohters like starters is a measure. You can try my sample file to create a measure not a calculated column to get it. Not recommend to create muti calculated columns which refer all columns in a table.

Please refer these two articles:

1. Avoiding-circular-dependency-errors-in-dax 
2. Calculated Columns vs Measures in DAX 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.