Forum Discussion
Dynamic X Axis based on measure
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.
Community Supportbaron33 ,
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
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
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.