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.

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.