Dynamic X Axis based on measure

[baron33]

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 

[v-yuta-msft]

@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]

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 · Accepted solution]

@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.

[amitchandak]

@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

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Segmentation

https://www.daxpatterns.com/dynamic-segmentation/

https://www.daxpatterns.com/static-segmentation/