Forum Discussion
Dynamic Categories based on a drop down
I have data that looks like: Item A B C D And I want users to chose which items they want to put into which category (which may change over time). I created a new table: C...
Anonymous ,
I think this is possible, Try using an IFELSE clause to the column and direct it to use the selected value in the slicer using the SELECTEDVALUE() DAX function whenever there is a filter being done on the slicer. If no slicer selection, then display the SWITCH() output. So roughly the DAX would look like below
ColumnName = IF( AND(HASONEFILTER(Category1), HASSONEFILTER(Category2)), <<Put the selected values here using the SELECTEDVALUE() DAX>>, SWITCH(<<expression>>))If this helps with your question, kindly appreciate with a kudo! If this solves, mark it as solution !!
Regards,
Thank you but I'm trying to build in flexibility where different users can make different changes while looking at the data. These users are not super technical and I'm hoping there is a way to write a Meausure so people can choose which items to put in which category based on a filter.