Forum Discussion

awalsh's avatar
awalsh
Helper I
5 years ago
Solved

Change Item Names In Legend from 2 Queries

Hi,    I need to change the item names in the legend of this pie chart.   However, the items in the legend are coming from 2 different queries, making it difficult for me to change their name. (T...
Need Help
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, awalsh ;

    May be try to modify the measure as follows:

    new =
VAR _relation =
    CALCULATE (
        MAX ( 'Table (2)'[Home] ),
        USERELATIONSHIP ( 'Table (2)'[ID], 'Table'[id] )
    )
RETURN
    IF (
        [Living]
            IN { "BH", "DD", "SA" }
            && _relation = "Home",
        [Living],
        _relation
    )

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi , awalsh ;

You could create a column to concatenate these two columns , and you colud use this column as "Legend".

new = CALCULATE(MAX('Table'[Living]),USERELATIONSHIP('Table'[id],'Table (2)'[ID]))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • awalsh's avatar
    awalsh
    Helper I
    5 years ago

    Thank you so much for your help!!! This is definitely getting me closer to what I'm trying to do. 

     

    There is just one thing - 

     

    I added the column "new" (screenshot below) but the formula is marking the BH, DD, and SA as "Home" where I need them to say BH, DD and SA respectively. The rest of the values are appearing correctly in the "new column".

     

    Is there a way to get these 3 items to show as BH, DD and SA instead of showing as "Home" while keeping the rest of the values in the new column the same? 

     

    Thank you again for your help!!! 

     

     

     

     

     

     

    • v-yalanwu-msft's avatar
      v-yalanwu-msft
      Community Support
      5 years ago

      Hi, awalsh ;

      May be try to modify the measure as follows:

      new =
VAR _relation =
    CALCULATE (
        MAX ( 'Table (2)'[Home] ),
        USERELATIONSHIP ( 'Table (2)'[ID], 'Table'[id] )
    )
RETURN
    IF (
        [Living]
            IN { "BH", "DD", "SA" }
            && _relation = "Home",
        [Living],
        _relation
    )

      The final output is shown below:

      Best Regards,
      Community Support Team_ Yalan Wu
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

       

      • awalsh's avatar
        awalsh
        Helper I
        5 years ago

        THANK YOU SO MUCH! This is perfect!!!!