Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

unichar issue

Hi all,

Greg_Deckler   amitchandak  mwegener  az38 TomMartens ImkeF 

im facing one issue while using unichar  with below measure.

GrossSalesKPI = IF(SUM(BPS_AIS_Order_Yotta_EDL_20[Diff Gross Sales])>=0,UNICHAR (9650),UNICHAR (128315))
it is giving me

down(red) arrow else up(green) arrow.

but my issue is even if my value is possitive also its showing down arrow (Red)

so anywhere im missing ? you can see below image grosssales value is possitive still its shwoing red down arrow.
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    it seems you created a column for KPI. try by converting the column "GrossSalesKPI" to measure with the same formula. 

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      it seems you created a column for KPI. try by converting the column "GrossSalesKPI" to measure with the same formula. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks everyone.  its because of measure its causing the issue. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      anything wrong in formulae?

       

      it is showing correct for max all posstive values. only some vaues its shwoing red.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        6 years ago
        So, what is the visual that you are using? Is it a matrix visual? What happens if you change that formula to just return the SUM and check the numbers being returned. I suspect it is some kind of filter context issue going on where the SUM is not coming up to what you expect it should. The formula is very simple and I do not see an issue with it. Although, for me 9650 is a black up arrow, not a green up arrow.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thank you for your qucik response. but im using card  i didnt see that option 

       

      and  did i miss anything?   or is this a bug?    im new to PBI so im bit confused. 

       

      could you please help on this

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    You first create a summed measure and add it to the chart and check if it returns the correct result:

    Sum_ = SUM(BPS_AIS_Order_Yotta_EDL_20[Diff Gross Sales])

     If the result returned is incorrect, you can try using the ALL() function.

     

    Best regards,
    Lionel Chen

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