visualizations
3 TopicsIs 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!679Views0likes2CommentsSmart tooltip for Matrix rows
Hi Dear Community, I am trying to use a column from a table (which has 1:* relationship with the table from which I constracted my matrix) as a tooltip for my matrix rows. But I want my tooltip to show the particular value from that column which corresponds to the value of the row of the matrix I hover over. I wuold appreciate your help. Thank you in advance!4.8KViews0likes1Comment