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_NameStart_date

Leave_date

Person A02/01/202012/01/2020
Person B03/01/202012/01/2020
Person C12/12/201903/01/2020
Person D12/11/201904/01/2020
Person E05/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

General Comment
Need Help

4 Replies

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    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?