Forum Discussion
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 symbol of 'Σ (sigma)'
Application Day XX Week XX month etc..... Count
14 2 0.5 1
30 4.1 1 1
.
.
.
Then my chart is simply line chart by Time to see when students tend to finish application
X axis: Time (Day or week or month)
Y asis: sum of rows
So I want to setup a measureby using slicer (I used to do it for dyanmic measure, e.g. sum / divide / average X
Here is my half function:
Interval = SWITCH(TRUE(), MIN(para_Interval_Select[Interval ID])=1, min(applied_interval_days_reserve]), MIN(para_Interval_Select[Interval ID])=2, SUM(INTON_AppTimelines[applied_interval_weeks_reserve]))
THe problem for me is that I can't use sum or min or whateve calculation --- becasue they will return to single point -- as they aggregrate these days / weeks.
Is there a function for me to select all the value in the Measure? without calculation
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.
4 Replies
- amitchandak
Super User
baron33 , I did not get it completely.
You want to change axis, you need to use the bookmark
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
If you want to change measure you can use the slicer
Segmentation
- v-yuta-msft
Community Support
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
- baron33Frequent Visitor
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
Community Support
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.