Forum Discussion

skaha7's avatar
skaha7
Frequent Visitor
2 years ago
Solved

Employee hierarchy count bar chart?

Hi All,   Bit of a newbie to this so I'm not sure if this is the appropriate place to ask. It's the visual I'm hoping for but could also see it potentially as a DAX related question or maybe even a...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi skaha7 ,

    Perhaps you could try the following.

    The data source is as follows.


    Select the Employee column and then unpivot the other column


    You can then rename the Attribute column and the Value column to get the following result.


    Then select the cluster's column chart visual and put in the appropriate columns.
    In this way Department, Division, and Company hierarchies are put into the chart.


    Please see attached pbix for reference.

    Best Regards,

    Dengliang Li

     

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

dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
2 years ago

Hello skaha7 , 

 

You can just write 3 measure each filtering  "Dept", "Div", "Comp" and add the same to the Bar chart it will work..

 

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

skaha7's avatar
skaha7
Frequent Visitor
2 years ago

Thanks for responding! 

 

I think I might be missing something. If I filter for Department A. It will limit the row counts for Div and Comp as well won't it? 

 

I could Hard code the company count since that wouldn't change. 

 

But filtering between Department A / B / C should also change between Division 1 & 2, but just at a different grain?