Forum Discussion
unichar issue
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.
Community ChampionDifficult to tell what is going on.
it seems you created a column for KPI. try by converting the column "GrossSalesKPI" to measure with the same formula.
Thanks everyone. its because of measure its causing the issue.
anything wrong in formulae?
it is showing correct for max all posstive values. only some vaues its shwoing red.
- Greg_DecklerSo, 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.
- amitchandak
Super User
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.