SIMPLE VALUE DATED REPORTS

[Ohene]

Hello everyone im new with power BI and i want to ask two very simple report questions and i will be very happy if the responses are kept in very simple language that a newbie will understand.

I have a report that i have created from importing data from a db2 database. There are no date columns in my data. just product_name, balances and totals. This report data i understand will update daily when refreshed. Therefore, balances and totals will update as well on a daily bases as the database is updated with transaction.

What i want to Achieve

-------------------------

1.I want to be able to introduce a date filter to this report, such that, when i choose a particular date, i will get the the last updated balances and totals as at 23:59(11:59pm) that day.

2. I want to be able to introduce a text filter to the viewers of the report, such that, users can type in product name(not select from a list), and then the list column will be updated by the typed text.

Kindly assist me in the simplest of language expression for my understanding. Thank you

[v-yuezhe-msft · Accepted solution]

@Ohene,

Firstly, to use Date filter to filter the visual, you would need to have date values in your table.

Secondly, you can use Text filter custom visual, which users can type in product name and filter the visual.

Regards,
Lydia

[v-yuezhe-msft · Accepted solution]

@Ohene,

Firstly, to use Date filter to filter the visual, you would need to have date values in your table.

Secondly, you can use Text filter custom visual, which users can type in product name and filter the visual.

Regards,
Lydia

[Ohene]

@v-yuezhe-msft

Thank you very much for the clarification. In this regard, can you suggest a way that a date field can be added to this automatically?

As in, is there a way to get a date column in the data as there is no date column in my original data. Is there a way to automatically add a date column each time the dataset is refreshed?

[v-yuezhe-msft · Accepted solution]

@Ohene,

You can add a calculate column using DAX below.

Date=NOW()

Regards,
Lydia