Forum Discussion
fabo
Advocate III
Advocate IIIInteraction between date slicer and line chart
Hi everyone. I need a line chart to be responsive when one date is selected from a date slicer. For example, if the selected date is december 31st, 2019, line chart should look like: But, if...
Hi fabo ,
This is a good approach, however you can also try one of other two options to not make another unrelated table:
- Make the slicer a Before or a Between slicer and that will return the values based on that selection
- Ohter option is to make the relationship between Date and Fact Table disable and the making use of the USERELATIONSHIP function create the measure that need the active relationship between both tables and use the same function as you have but with only one date table.
Regards,
MFelix
MFelix
Super User
Super UserHi fabo ,
This is a good approach, however you can also try one of other two options to not make another unrelated table:
- Make the slicer a Before or a Between slicer and that will return the values based on that selection
- Ohter option is to make the relationship between Date and Fact Table disable and the making use of the USERELATIONSHIP function create the measure that need the active relationship between both tables and use the same function as you have but with only one date table.
Regards,
MFelix
