CODEWITHSUNDEEP
powerbidaxrowsselectedvalueslicers
Simen Andreas Knudsen
Simen Andreas Knudsen

Reputation: 1

Power BI DAX - Measure to change name of row value

I need some help creating a measure to change the name of "FROM_USER" in the slicer here. I think I need to use the function SELECTEDVALUE, but I have not managed to get it working. So, the column has only two values, CRAWLER and FROM_USER. Any suggestions would be helpful!

See picture

Upvotes: 0

Views: 2411

Answers (1)

smpa01
smpa01

Reputation: 4282

Measures can't be used as slicer values. If you want the column values to be changed and yet to be used in a slicer, you need to create a calculate column to change that.

Column = IF('Table'[Column1]="FROM_USER","desiredValue","CRAWLER")

If you are really keen on using a measure to slice, you need to build a disconnected table and follow the method described here. But the performance will take a hit depending on how complex your data model and calculations are.

Upvotes: 1

Related Questions