Forum Discussion

arazakov's avatar
arazakov
New Member
9 years ago
Solved

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. ...
  • Sean's avatar
    9 years ago

    arazakov

    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: