Forum Discussion
BuistJF
Helper I
Helper IToggle between different measures
Not sure if this is possible in PBI and from looking at it paremeters maybe the way forward or whether there is an option to dynamically adjust the DAX shown below. I have a line chart that has 3...
Hi BuistJF ,
You could create a disconnected table to use for the slicer.
Create a new measure using SelectedValue to get the selected value from that slicer:
https://learn.microsoft.com/en-us/dax/selectedvalue-function
Then use a Switch statement to determine which measure to return based on the value from above
https://learn.microsoft.com/en-us/dax/switch-function-dax
djurecic
Super User
Super UserHi BuistJF ,
You could create a disconnected table to use for the slicer.
Create a new measure using SelectedValue to get the selected value from that slicer:
https://learn.microsoft.com/en-us/dax/selectedvalue-function
Then use a Switch statement to determine which measure to return based on the value from above
https://learn.microsoft.com/en-us/dax/switch-function-dax