Forum Discussion
Show rows based on selected date
NMDGA , Try below steps
Firsr Create a Calculated Column
Create a calculated column in your fact table that evaluates to 1 or 0 based on your conditions.
IsVisible = IF(
[Reporting date from] <= [Selected Date] &&
[Reporting date to] >= [Selected Date] &&
[Schedule effective date] <= [Selected Date],
1,
0
)
Then modify the Hide/Show Measure
Ensure your hide/show measure is using the calculated column:
HideShowMeasure = SUM([IsVisible])
Use the Calculated Column in the Visual
In your table visual, use the RID and the selected date measure. Apply a visual-level filter to show only rows where IsVisible = 1.
If you need a measure to show the selected date uniformly, you can create a measure like this:
SelectedDateMeasure = SELECTEDVALUE('Calendar'[Reporting date from])
Applying Filters
Add the RID and SelectedDateMeasure to your table visual.
Apply a visual-level filter on IsVisible to show only rows where IsVisible = 1.
hi bhanu_gautam , I am afraid we cannot use the selected value function in calculated column , hence when i try to create the calculated col as you suggested i am unble to get the result as everything is 0.