Dynamically change the data Power BI reads from a table based on the current week day.

[Klaud]

Hi!

I am struggling to find a solution to the following problem. Perhaps the community would be able to help me with the matter :). I am fairly new to Power BI and I am still learning its basics. 

The problem I am facing is that I have got a table with values that are stored in columns named "Mon", "Tue", "Wed", "Thu", "Fri", "Sat". Now, what I would like to do is based on the current day, read the data from a column for the following day (Today read the data for Wednesday etc.). Hopefully this makes sense. 

Is this achievable at all?

 

Thanks

[Klaud]

Hi @Idrissshatila 

This seems to be working really well. Thank you for that.

I might be a little picky here but is it also possible for power BI to automatically detect, which day of the week we are currently in and only display the data for the next day instead?

[Idrissshatila]

@Klaud ,

yes if the days were on rows as values not as column names.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Idrissshatila · Accepted solution]

Hello @Klaud ,

try using field parameters, learn how here https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin