Forum Discussion

Do5779's avatar
Do5779
Helper II
3 years ago
Solved

Compare value to coloumn

Hi experts,    my problem is the following one:   I have a map with some locations in power bi, which were sucessfully displayed. Now I would like to use the auto zoom and change the colour of th...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    Hi Do5779 ,

     

    Is this above you want?

     

    If yes, please refer the pbix in the attachment. if no, please provide some example data and expect result.

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

Do5779's avatar
Do5779
Helper II
3 years ago

v-chenwuz-msft: Your report works fine with the countrys, but what if I want e.g. to change countrys to Gross Sales, I dont get the desired result. Fore Example for the gross Sales 1799 only Canada should be green and the rest is blue, but no colour change. My question is because in my fault I have Ids with addresses and this is nearly the same. 


(I didn't find the tag to upload the report 🤔)

  • Do5779's avatar
    Do5779
    Helper II
    3 years ago

    Here is the solution as a Video, but in my case it wont work.

    DAX Fridays! #212: VALUES vs SELECTEDVALUE to conditional format a line chart - YouTube


    For a Test I did it how it was explained and it works:

    Test4 = 

var selectvalue = VALUEs(Abfrage1[id])

return
If(selectedvalue(Tabelle[ID]) in selectvalue, "y" , "n")


    but for the real data with the same code:

    Test4 = 

var selectvalue = VALUEs('Abfrage1'[Index.1])

return
If(SELECTEDVALUE('Member'[Index.1]) in selectvalue, "y" , "n")


    I get only "y" as the results...