Forum Discussion

Kaviraj_S's avatar
Kaviraj_S
New Member
4 years ago

Can we create a Bar Graph between 2 measure columns ?

Here is my scenario

 

This is our structure of data.

Requirement : Bar Graph plot between Employee Count (Y Axis) & Attendance Frequency (X Axis)

There are 2 Employees in the sample. So, Y axis would be <= 2 in this case.


Site is used in Slicer (Multi Select)

  • If no site is selected, the graph should have 2 bars, with y axis value of 1 under x axis value of 19 and another bar with y axis value of 1 under x axis value of 21. (1 Employee attended 19 times and 1 Employee attended 21 times).

 

  • If one site is selected, say, “LOCATION 3”, the graph should have 2 bars showing count of 1 under 11 and 1 under 3 (1 Employee attended 11 times in "LOCATION 3" and 1 Employee attended 3 times in "LOCATION 3")

    Any possibility to achieve this ? May be using DAX or Power Query ?


    Thanks in Advance

    Kaviraj
Need Help

2 Replies

  • johncolley's avatar
    johncolley
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Kaviraj_S , The behaviour you are requiring is the default behaviour of the bar chart. Select the bar grpah visual, put UserID in the y-axis and Att_Freq in the X-axis. 

     

    If this answer solves your problem please mark it as a solution!

     

    • Kaviraj_S's avatar
      Kaviraj_S
      New Member
      4 years ago

      Hey johncolley ,

       

      Thank you very much for looking into this.

      Here is further more detail of the issue I am facing.

      We need in "Clustered Column Chart".

      When single location is selected, the plot is perfect.

      When multiple sites are selected, the Employee count & Attendance count should be aggregated and shown as per the locations selected in slicer.

      Below is the view I am getting on "All" locations selected.

      This is wrong display. When you aggregate 2 employee values, across all sites selected, it  should show as (1 Employee attended 19 times and 1 Employee attended 21 times)


      Thanks,

      Kaviraj