Change Dashboard View by Date

[DBook]

Hi all,

I am building a food tracking app and I structured it so that food and drink are in separate tables to allow for multiple items for each day. My thought is to use a Dashboard as the main user view and display a meal table and a drink table for the day along with some other elements like total calories for the day, etc.

One thing I haven't been able to figure out is how I can control what day the dashboard is showing. It defaults to today, but I want to be able to choose a different day - hopefully in two ways if possible:

1. By using some sort of next and previous controls to just go forward and back incrementally by day
2. By entering a date in a field or picking from a calendar view

Any help would be really appreciated!!!

[DBook]

I'm getting the sense that there isn't a whole lot of community support here.

I did figure out one simple fix that I had overlooked: using a "detail" type for a view has the option of "Slideshow Mode" which enables previous and next buttons. I can work with this. I just need to figure out how to have one panel in my dashboard with the slideshow arrows can affect another dashboard panel that isn't in the same table (it works when the other panel is drawing it's data from the same table). I'm sure this it a "Ref" issue, just need to figure out how to set it up.

My other original question was to be able to navigate to a specific date. The more I look into the "calendar" the less useful it looks like it is - also too big for my dashboard.

I just want to be able to enter a date in a field or something to update the dashboard to that date. Anyone?

[dbaum]

---

@DBook wrote:

I'm getting the sense that there isn't a whole lot of community support here.

---

My experience is the opposite.

See  Interactive Dashboard - Google Cloud Community . 

[DBook · Accepted solution]

I figured out a solution to the second half - I have created a date field on my dashboard that sets the date for all other dashboard items without using "interactive dashboards".

1. Starts with creating a Date Filter table with a Date Filter column
2. Then I created a Reference View for this which is a Detail type that only shows the on column: Date Filter. So all you are seeing in this view is a date selector field.
3. I put this at the top of my dashboard.
4. Then I created a Slice in each table that I want on the dashboard and create a Reference View for each one of those. In that slice, I have an expression that checks if the Date Filter column is blank or if there is a date and if there is a date, use that for this slice.
5. IF (ISBLANK(ANY(Date_Filter[Date Filter])), True,
   [Date] = ANY(Date_Filter[Date Filter]))

Now, my dashboard and all the ref views in it defaults to today, but I can easily change to another date.

I find this useful in my case to check and see what was entered on a certain date, make changes, etc.

Is it elegant? No. Are there better ways to do this? Probably. As for the first part with the next/prev buttons: Slideshow mode doesn't really work for this now, so I'll have to figure something else out, but I can live with this for now.

I hope this helps someone else!

[dbaum]

Your approach is also a typical implementation. Enhanced Dashboard || Sample App - YouTube