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