Showing information only on certain day of week

[kmcallister]

Hi,

I have a requirement to show data only on a monday of each week. Basically, I want a crosstab (table) that will show the upcoming weeks goals/targets, but I then want to not show this for the rest of the week. 

My thought is to create a Today function and then join that back to my target table, but im not exactly sure how that would work. Since PBI does not have the concept of Show/Hide like tabluea, I'm ok with displaying a blank table for 6 days. Does anyone have any ideas how to accomplish this? 

Also, We're using PBRS so there will be no interaction from the end user (For example entering a parameter). 

Thanks,

Kevin

[jthomson]

I'm assuming you're showing some measure(s) in your tables, what you could try is to use an IF function in conjunction with it, something like:

NewMeasure = if(weekday(today())=2,[oldmeasure],blank())

which should retain the value of your existing measure if it's Monday and show a blank otherwise

[kmcallister · Accepted solution]

I think that would work, but the issue is that i have a table to display this information. I was able to figure out a hack to this...

On my Target/Goals table, I created a measure to calcualte today's date (Format(Date, "MMMM")) to get day of the week (IE. Monday, Tuesday, Etc.). I then created another table with Monday as the only value. I joined Monday to the date format column. I then created a dashboard filter and selected Monday. This allows me to hide the table on every other day that is not monday.  

Probably not the best solution, but it works