Forum Discussion

baron33's avatar
baron33
Frequent Visitor
6 years ago
Solved

Dynamic X Axis based on measure

My date set has these columns  -- these are about how much time one student need to finish his application   then each row is count 1  (These day / week / months are numeric so in date set it has a...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    baron33 ,

     

    In line visual, measure cannot be used as X-axis, you need to convert the measure into calculate columns and create a slicer based on the calculate column to filter the X-axis.

     

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

baron33 ,

 

Not sure what's your requirement, but in power bi, measure will always return an aggregation value. So you may use calculate table or generate such a table using power query instead. 

 

Regards,

Jimmy Tao

  • baron33's avatar
    baron33
    Frequent Visitor
    6 years ago

    This is the chart I need to prouduce:

     

    Now the axis is based on days -- I want to create one measure (by using slicer I think?) -- so I can dyanmicly change axis from number of days to weeeks to months easily

     

    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      baron33 ,

       

      In line visual, measure cannot be used as X-axis, you need to convert the measure into calculate columns and create a slicer based on the calculate column to filter the X-axis.

       

      Community Support Team _ Jimmy Tao

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