Forum Discussion

mbherbener's avatar
mbherbener
Regular Visitor
10 years ago
Solved

How do we use treemap color saturation?

Hi,   I'm trying to use the 'Color Saturation' setting for a Treemap with current PowerBI Desktop, but when I drag a field to the "Drag Data Fields Here" box the yellow border lights up momentarily...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi mbherbener,

     

    We are not able to use Details and Color Saturation at the same time in a Treemap visual. We can only put fields in Details or Color Saturation separately each time.

     

    Best Regards,
    Qiuyun Yu

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

I believe that field has to be Numeric, at least that is what works for me. That being said, if you drag a Text field to it, it should switch it to "Count of Column". What kind of field are you using?

mbherbener's avatar
mbherbener
Regular Visitor
10 years ago

I've tried numeric - whole number and decimal.

 

do you know if it has to be in a certain range - 0 - 1 or 1 - 100 or something?  Are there other limits on when/how you can use it?

 

thanks!

 

Martin

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    10 years ago

    Hi mbherbener,

     

    In your scenario, please place fields for Group, Values and Color Saturation properties. Then rectangles' color will display as the same color but in different color saturation. See:

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

    • mbherbener's avatar
      mbherbener
      Regular Visitor
      10 years ago

      Can I use Details AND Color Saturation at the same time?  Or do I have to choose one vs the other?

       

      thanks!

       

      Martin

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        10 years ago

        Hi mbherbener,

         

        We are not able to use Details and Color Saturation at the same time in a Treemap visual. We can only put fields in Details or Color Saturation separately each time.

         

        Best Regards,
        Qiuyun Yu

  • KGrice's avatar
    KGrice
    Icon for Memorable Member rankMemorable Member
    10 years ago

    I tried on one of mine to use a measure, number column, and text column, with values ranging from 1 to 30,000. All worked, and you should see your tree map going from many different colors to all shades of the same color if it's working. Whatever you drop in the Color saturation box should stay there. I'm not sure why yours is having issues.

     

    Power BI has a treemap tutorial you might try following, just to see if you're overlooking something.

     

    If nothing in there stands out, are you on the latest version? There were at least two versions released in July, the second to correct the first. Several people were having various issues with visuals on the first release.