Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using switch for a non-measure field.

Hi, I would like to add some arrows in power bi to a table. I saw that switch is a good way to do this. The problem is that none of the fields in my table are measures. They are all calculated from dynamics 365. So one field is a percentage field that I would like to use. What would be best way of going about this? 

 

Thanks. 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous than that is your answer. You should add a new column if you want to put switch function on columns.

     

    Would appreciate Kudos 🙂 if my solution helped.

6 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You can use UNICODE to get up arrow and down arrow, then use them in IF or SWITCH function, see more: https://exceleratorbi.com.au/dax-unichar-function-power-bi/.

     

    Down = UNICHAR(11167)

    Up = UNICHAR(11165)

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

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

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous it doesn't need to be measure to use switch, if  you share what you are trying to do and some sample data, we can help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, 

       

      Here's a picture of what I'm trying to do. It only seems to have measures available for me. 

       

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous are you adding ArrowField as a MEASURE