Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Custom Current Selection

Hi All,

 

Can someone please us that the below is possible in power bi or not?

 

Need Help

5 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    When filtering on "fulldatekey" in the slicer, you want to get a column/measure "Time selection", right?

    Please tell me more details so to analyze for you.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    As tested, it seems impossible.

    When selecting 2005/1/1~2006/8/29, i can only get all selected years and selected months.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    I find a workaround.

    Create a measure

    Measure = IF(ISBLANK(DISTINCTCOUNT('calendar'[Date])),BLANK(),MAX('calendar'[month name]))

    Add it in the value field of the matrix, add "month name" from "calendar table" to the matrix.

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.