Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Prevent spliting when using LYTD (pbix attached)

I can't make the below behaviour: pbix here: https://drive.google.com/file/d/1tpGKvL_ST1L7YgDkDFqqLqfKb0FEjfcL/view?usp=sharing         I have a single selection filter on Year, and when I sele...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , for that you need to have column that merge these two

New type = if([Type] in {"Inter", "Locale"} ,"Locale", [Type]) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for your answer, but it is dynamic... It can happen with more than one client in the future (or different type names)

    (The only good thing is: that if they switch, they do it on 01-Jan).

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi， Anonymous 

      I'm not sure what you mean by ‘dynamic’.

      Why not consider using the field 'Customer' in table visual directly?

      In addition to manually creating a calculated column as mentioned by amitchandak , you can also try to right-click the field, and select New group from the menu.

       

      Result will show as follows:

      Best Regards,
      Community Support Team _ Eason