Forum Discussion
Another IF with SELECTVALUE not working
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.
3 Replies
- bhanu_gautam
Super User
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.
