Forum Discussion
Selected value in graph
Hi all,
there is a way to show in graph only up to selected month value?
For example, rather than show all month when i select March,
I want to show up to march, like this:
My slice has unique selection value. I know that i can change to visual between, but i was wondering if i can see like this,
Thanks and sorry for my english.
HI iurilino,
You can add a calculated column to extract correspond month number from these text value, then you can use it on slicer with 'before' mode(less than or equal to) to filter records:
MonthNum = MONTH ( DATEVALUE ( [MONTH] & "/1" ) )Regards,
Xiaoxin Sheng
3 Replies
Yes, It depends on the formula and relation.
You can also try relative date slicer
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
I forgot to mention, my month is not date format, so i cant use relative on slice
Is like this:
HI iurilino,
You can add a calculated column to extract correspond month number from these text value, then you can use it on slicer with 'before' mode(less than or equal to) to filter records:
MonthNum = MONTH ( DATEVALUE ( [MONTH] & "/1" ) )Regards,
Xiaoxin Sheng
