Forum Discussion

Krcmajster's avatar
Krcmajster
Helper IV
7 years ago
Solved

Dynamic column changing

I am not sure this is possible but better to ask.   So I have a column with clasiffication by size SQM:   Example: SQM Class <1000 1000-5000 5000-10000 >10000   Next to it I have a similar...
Need Help
  • tex628's avatar
    tex628
    7 years ago

    To do it you will need to change the datamodel. Instead of having SQM and SQFT in two seperate columns you would need to have the values in the same one:

    SizeClass
    < 1000SQM
    > 5000SQM
    < 10000SQFT
    > 20000SQM
    < 1000SQFT
    > 5000SQM
    < 10000SQFT
    > 20000SQFT


    With this you can create a slicer on the class column which should give you the result ur aiming for.

    Br,
    Johannes

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Krcmajster 

I cannot fully understand your expected output.Could you show us an example about your expected output with sample data?As far as i know,calculated column could not be dynamic changed by slicer but measure could.Please share more details for us to help with you.

Regards,

  • Krcmajster's avatar
    Krcmajster
    Helper IV
    7 years ago

    v-cherch-msft  see attached photos:

     

    Size in SQFTSize in SQM

     

    I want the categories (classes) to change when I select different measure from the slicer (SQM, SQFT)

    • tex628's avatar
      tex628
      Community Champion
      7 years ago

      You want the same diagram to be able to switch between SQM and SQFT depending on what you filter on in your slicer?