Forum Discussion
getting selected date value from a visual
Hello experts,
Is there anyway to save selected date in the visuals below (1/5/2021) ?
I am willing to use this date to filter another visual which is showing latest date trend when nothing is selected on the date visual else it will show trend selected date trend.
Thanks
Can you just use the native crossfiltering behavior of visuals to get that effect?
Change how visuals interact in a report - Power BI | Microsoft Docs
Pat
3 Replies
- mahoneypatMicrosoft Employee
Can you just use the native crossfiltering behavior of visuals to get that effect?
Change how visuals interact in a report - Power BI | Microsoft Docs
Pat
- AnonymousNot applicable
Hi Minakshi ,
Based on my test, you need two tables without relationships between them.
Then you could use the following formula to create a measure and apply it to visual-filter pane like this:
Please take a look at the pbix file here.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- MinakshiResolver I
Hi Anonymous
Thank you so much. It somehow doesn't solve the problem. Other visual which I want filter doesn't have date. The other visual doesn't get filtered with max date. works fine with default behaviour of BI