Forum Discussion
TRICKY - Line and Bar Chart Plot
1. Instead of using Month Name like 'Jan 2020 ' or 'Feb 2020', you can use date eg. First day of the month. Instead of Jan 2020 - 1 Jan 2020. Which gives you the possibility to use some time intelligence functions.
2. Create a calculated table using the following formula
Months = DISTINCT(Table[Month])
3. Use Slicer for the Month from this table and not from the Original table
4. In the original table create a measure called MonthFilter
MonthFilter =
var selectedmonth = EDATE(DATEVALUE(SELECTEDVALUE(Months[Month])),12)
RETURN
IF(MAX(Table[Month]) <= selectedmonth,1,0)
4. Create a line chart for your data
5. In Visual level filter, add MonthFilter and set as 1Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Solution Sage1. Instead of using Month Name like 'Jan 2020 ' or 'Feb 2020', you can use date eg. First day of the month. Instead of Jan 2020 - 1 Jan 2020. Which gives you the possibility to use some time intelligence functions.
2. Create a calculated table using the following formula
Months = DISTINCT(Table[Month])
3. Use Slicer for the Month from this table and not from the Original table
4. In the original table create a measure called MonthFilter
MonthFilter =
var selectedmonth = EDATE(DATEVALUE(SELECTEDVALUE(Months[Month])),12)
RETURN
IF(MAX(Table[Month]) <= selectedmonth,1,0)
4. Create a line chart for your data
5. In Visual level filter, add MonthFilter and set as 1
Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.