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 i...
bhanu_gautam
Super User
Super Useralecev 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.
Updated post with link to pbix