Forum Discussion
Solved
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: ...
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
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