Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Advice Please Variation Visual

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 ...
General Comment
Need Help
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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].