How to make a manually entered date field (visual calculation) as a filter in a table visual

[OceanExplorer]

Hello, I created a sample report using the data below:


This is the table visual in the report. Both "Customer Support Activation Date" and "Remaining Months" are created using Visual Calculation. The logic is that a person can manully enter a date value for "Customer Support Activation Date", then "Remaining Months" will automaticall generated based on this formula: 

Remaining Months = DATEDIFF([Customer Support Activation Date], [Customer Support End], MONTH)

Is there a way to allow report users to change the Customer Support Activation Date as how they can do it as a filter? Rather than modifing the code in the formular bar: 

Customer Support Activation Date = DATE(2024, 10, 1) ?

Some limitations: In reality, the report will be built on a shared semantic model, so can't create columns or parameters. We can only create measures and visual calculations.

[v-sgandrathi]

Hi @OceanExplorer,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[Anonymous]

Hi @OceanExplorer,

Current power bi does not support to create dynamic calculated column/table based on filter selections. They not works on the same level and you can't use child to effect its parent.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

BTW, power bi also not supports to writeback data to the database. Perhaps you can try to use the power apps visual with external app to submit data, then you can get data from remote data source that you used to store these submitted data.

Power BI & Power Apps: A Guide To Data Write-back & Refresh 

Regards,

Xiaoxin Sheng

[Deku]

As long asnone them them doesn't filter that table then yes you can use that. You can add a slicer and grab it's value, and use it to populate your activation date

[OceanExplorer]

We have some other date tables in the data model, is it possible to leverage that? 

[Deku · Accepted solution]

This is not supported by visual calculations.

You would need to use a composite model and a date table for the selection