Another IF with SELECTVALUE not working

[alecev]

Hi,

I'm facing a problem since days that i cannot solve.

I found some similar help messages in this forum with "IF with SELECTVALUE" in the object, but no one helped me to solve mine.

My problem is that I have a list of suppliers with Names, IDs and a Score:

ID	Name	Score
3498751	Supplier Name 1	2,17
3952340	Supplier Name 2	4,16
7092052	Supplier Name 3	4,33
9700018	Supplier Name 4	4,32
7511869	Supplier Name 5	5,87
577385	Supplier Name 6	6,14
7282137	Supplier Name 7	4,33
6997920	Supplier Name 8	5,03
472806	Supplier Name 9	4,16

I can show an histogram with names (on X) and scores (on Y) or IDs (on X) and scores (on Y).

But I need a different view: I need to show all scores in y-axis, and all IDs in the x-axis, except that one that i want to show with its Name, example:

I need this view when I have to show to "Supplier Name X", its score compared to other suppliers, without let him know who are other suppliers.

So I created a second table with only Supplier Names, using it to select in the slider.

Then I created a new x-axis column in the following way: 

IF('Supplier Table'[Names] = SELECTEDVALUE('Supplier Names'[Names],""), 'Supplier Table'[Names], 'Supplier Table'[IDs])

but it does not work.

Any ideas how to solve?

link to pbix : https://drive.google.com/file/d/1W3ZjgOwHXZdgGtluocEhSw5opltmV9_A/view?usp=drive_link

[bhanu_gautam]

@alecev Create a new calculated column in your 'Supplier Table' to determine whether to show the Name or the ID based on the selected supplier.

DAX
NewXAxis =
IF(
'Supplier Table'[Names] = SELECTEDVALUE('Supplier Names'[Names], ""),
'Supplier Table'[Names],
'Supplier Table'[IDs]
)

Use this new column as the x-axis in your visualization.

[alecev]

Updated post with link to pbix

[alecev]

sorry but it is exactly what I tried and did not work.