Forum Discussion

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

Hi, Amz_123 

 

Based on your description, you may create two measures as follows and put them in the Treemap visual.

 

Value Based Selectio Units = if(SELECTEDVALUE(Selection[Selection])="Units",int([Total Units]),0)

Value Based Selectio % Share = if(SELECTEDVALUE(Selection[Selection])="% Share",[% Share]*100)

 

 

Result:

 

Best Regards

Allan

 

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

  • Amz_123's avatar
    Amz_123
    Icon for Helper I rankHelper I
    6 years ago

    Hi v-alq-msft 
    Thanks for your reply. The solution which you have given doesnot seems to work. Please provide if any other idea you have.
    Thanks in Advance.
    Amz

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

      Hi, Amz_123 

       

      Could you please show me your error message? Based on my tests, It is a relatively good workaround for a tree map visual.

       

      Best Regards

      Allan

      • Amz_123's avatar
        Amz_123
        Icon for Helper I rankHelper I
        6 years ago

        Hi v-alq-msft ,

        I want resultant values to be in single measure, when I select units then value displayed in tree visual should not have decimal point. When I select % Share then value displayed in tree visual should have 1 decimal point. I cannot use 2 measures for every single visuals because there are lots of visuals to show data similarities for Units and % Share.Please Guide.

        Thanks in Advance
        Amz