Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
  • Thejeswar's avatar
    Thejeswar
    1 year ago

    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,

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

I create a table as you mentioned.

Then I think you can create a measure.

Measure = SUM('Table'[Sales])

So you can add visuals as you want.

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.