Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Donte
Regular Visitor

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

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!

 

Screenshot 2023-05-09 095004.jpg

2 REPLIES 2
Donte
Regular Visitor

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

eliasayyy
Memorable Member
Memorable Member

can you provide sample data please?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.