Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

displaying negative values in Treemap

Hi All,

I have a requirement where I need to show top 5 and bottom 5 values basen on measures for different countries and I am using treemap as a visualization. But I have to display negative values as well in the graph and treemap has a limitation where it can’t display the negative values.

Is there a way around for this? if not please suggest a better visualization to showcase the data.

 

 

Thanks in advance,

Rakesh

 

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi rakeshreddyp, 

    You could try to measure to show negative  value,  or you could use abs() function to change negative value and use conditional formatting to show it. You could referto my sample.

    Best Regards,
    Zoe Zhi

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

2 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi rakeshreddyp, 

    You could try to measure to show negative  value,  or you could use abs() function to change negative value and use conditional formatting to show it. You could referto my sample.

    Best Regards,
    Zoe Zhi

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

    • mircogia's avatar
      mircogia
      Regular Visitor
      6 years ago

      hi CST,

       

      when i look at my treemap the "i" says "negative values aren't supporte and are being deslayed as zeroes"..how do i cange it to "as abs values" so i can se the numbers on my graph?

       

      thanks