Forum Discussion
How to create an interactive calendar- Beginner
BHoughton , There seem to few things here.
If you need calendar table, You can create a calndar table and end it on Today of max date of you data.
example
Date = calendar(min(Table[Date]), Max(Table[Date]))
Date = calendar(date(2018,01,01), Today()).
For visual you can use slicer/filter or timeline slicer or any other
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?tab=Overview
There can not be popup, Visual interact with each other, so they will refesh. (URL can open external window)
Or you can use drill through - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.