Forum Discussion
Creating a measure displaying whether a value in row is selected or not
If this is the reason then the only other method i can think of is to colour each line based on the text value.
as power bi does not allow conditional formating based on text only number then you would need to create a rank for each of the values. for example
Measure = RANKX('table'[TEXTTOCHECK])You can then use this Rank Measure in a conditional fomat using a rule and give each rank a diffrent colour.
this would not allow you to see based on a selected value but might still give the view you are looking for by looking at the colours between each of your choosen colour
This would look something like this
There May be a way to conditionaly format the rows based on rank and a selected value in a slicer but im not sure i will explor this
The thing is that the data should not be filtered when selecting a row.
The reason for doing it is to find a pattern.
The rows will be later sorted by a date and the same texts won't be next to each other.
The goal is to select a text to highlight all the same texts and check whether the values between those highlighted texts repeat. So by using a slicer, there aren't any rows between the highlights which is why using the alternatives won't work.
Solution SageIf this is the reason then the only other method i can think of is to colour each line based on the text value.
as power bi does not allow conditional formating based on text only number then you would need to create a rank for each of the values. for example
Measure = RANKX('table'[TEXTTOCHECK])
You can then use this Rank Measure in a conditional fomat using a rule and give each rank a diffrent colour.
this would not allow you to see based on a selected value but might still give the view you are looking for by looking at the colours between each of your choosen colour
This would look something like this
There May be a way to conditionaly format the rows based on rank and a selected value in a slicer but im not sure i will explor this
This could be a possible solution to my problem. Thanks for helping me out!