Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I am having an issue with the selected value function not populating correctly.
I have a list of policies and their inception date (policy start date) and expiry date (policy end date) spanning several years. I want users to be able to view only policies which are in-force/live at 1st of each month using a slicer.
I created an unrelated date table which will be used for the slicer. When a user selects a date from the slicer I want to tag or filter only policies which are in-force at that date. If the slicer date is between the inception and expiry date it would be considered in-force.
In my main able have a selected value measure
Solved! Go to Solution.
Change the measure to
Selected_Date =
SELECTEDVALUE(Date_Table[Date])
I would also recommend you turn off "Auto time/Date" in the file's options under "Data Load" (since have created a date table with columns), and mark the Date table as such in the ribbon. (but save a backup file in case you need to redo measures)
Proud to be a Super User!
Paul on Linkedin.
Change the measure to
Selected_Date =
SELECTEDVALUE(Date_Table[Date])
I would also recommend you turn off "Auto time/Date" in the file's options under "Data Load" (since have created a date table with columns), and mark the Date table as such in the ribbon. (but save a backup file in case you need to redo measures)
Proud to be a Super User!
Paul on Linkedin.
Paul thank you so much - this worked!
An annoying small change to make this all work but much appreciated.
Adam
Hi @adamfoster ,
Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Apologies my company blocks external sharing.
New link here should be public.
thank you
Can you make the download link for the sample PBIX file public please?
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |