Can we create a Bar Graph between 2 measure columns ?

[Kaviraj_S]

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

[johncolley]

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]

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