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].
  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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.