Slicer page navigation

[Hussein_charif]

im having an issue in using a column for page navigation. i have a table called access page that has the user email and page names, which is identical to the pages names in the report, but when i add a button and put the action type to navifation and do conditional formatting and click on the page column, it doesnt select the column.

it should show the summarization as "first", but it is not and i cant select it. what could be the problem?

[AnkitaaMishra]

Hi @Hussein_charif , 
I have tried replicating your issue and I am able to see the summarization option as shown below : 

COuld you please check once if the column data type is set to "text" : 

Thanks,

Ankita

[Hussein_charif]

hi, yeah i tried as well and it worked in another report, but in this one it is not

[AnkitaaMishra]

@Hussein_charif If thats the case then like @SamWiseOwl suggested, creating a measure would be a better approach and then use it for conditional formatting, make sure to set the correct data type.

[Hussein_charif]

@SamWiseOwl 's solution worked, thank you!

[SamWiseOwl · Accepted solution]

Hi @Hussein_charif 

Is the column set to text data type?

You could create a measure and use that.

[Hussein_charif]

the measure works, thank you !

[Hussein_charif]

hello, yes it is