Forum Discussion
unichar issue
Hi all, Greg_Deckler Mariusz 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 G...
Anonymous , this file has a lot of other stuff. But refer to visual on page no 13. I create a combined visual and used unichar too.
Refer to the measures created for unichar and color
https://www.dropbox.com/s/bu47m5ek7sr9v8t/sales_analytics_v2.pbix?dl=0
I wanted to clean up this file. But did not get time.
it seems you created a column for KPI. try by converting the column "GrossSalesKPI" to measure with the same formula.
anything wrong in formulae?
it is showing correct for max all posstive values. only some vaues its shwoing red.
Greg_Deckler
Community Champion
Community ChampionSo, 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.