Forum Discussion
Two values in x axis
Hey all,
I am trying to migrate from excel to bi, and was wondering if its possible to have two values in the X - axis as I have in Excel.
Please take a look at the screenshot to understand. Notice how upon pressing the +/- on the bottom right, I can see the data for an agent and the days.
In BI, i am able to see the metrics, but cant display Agent name and the date. Only one of those x-axis values is available at a time.
Let me know if this makes sense, Thanks!
1) Create a Column Chart in PBI
2) Place your Measure in the Value field
3) Place Name and Date in the Axis (Name should be above Date)
4) in the top left corner of the chart click the Expand All button (that's the 3rd button from left to right)
5) Set up the slicers in PBI the same way you have them in Excel
Now once you select Barbara from the Agent Slicer and Inbound Call Type - you should get the same result as you did in Excel.
Let me know if you have any questions!
Hope this helps! :smileyhappy:
1 Reply
1) Create a Column Chart in PBI
2) Place your Measure in the Value field
3) Place Name and Date in the Axis (Name should be above Date)
4) in the top left corner of the chart click the Expand All button (that's the 3rd button from left to right)
5) Set up the slicers in PBI the same way you have them in Excel
Now once you select Barbara from the Agent Slicer and Inbound Call Type - you should get the same result as you did in Excel.
Let me know if you have any questions!
Hope this helps! :smileyhappy: