Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab?

Anonymous — Tue, 09 May 2023 14:01:47 GMT

Hello,

I want to use a slicer in the Reports tab that would allow a user to change a varible that would subsequently change a column formula created in the Data tab.

For Example, the below image shows a date slider (let's call this date variable "SlicerDate"). This would be a visualization in the reports tab that any user can interact with. I want to create an IF statement in the Data tab that states, IF(X<SlicerDate, "Earlier", IF(X>SlicerDate, "Later")). Although the actual column formula in the Data tab would not change, the "SlicerDate" within the formula would change according to the date applied to the slicer.

The reason for this is there are many people who will view this report themselves and would like to adust the returned variables based on a specific date, but not all people will know how to change data portion of the PBIX file or online file. I want users to be able to change the variable returned in the Data tab without leaving the Reports tab.

Any assistance or suggestion is greatly appreciated.

Thank you!

Re: Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab?

eliasayyy — Tue, 09 May 2023 15:07:31 GMT

can you provide sample data please?

Re: Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab?

Anonymous — Wed, 10 May 2023 14:30:24 GMT

Sorry, I do not have a sample data set. But if you need more information. I am more than happy to provide.

topic Re: Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab? in DAX Commands and Tips

Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab?

Re: Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab?

Re: Is it possible to use a visualization/slicer, that edits a DAX formula in the Data tab?