Forum Discussion
Select a text value when no selection in a filter is selected
Hi community,
I have a table with names of owners which I use as a slicer. I use a card to display the names of the owners in big letters once they are selected. Everything is working great yet I can't define what value is there when no owner is selected i.e., in the beginning there is no owner selected. Any idea how to change this text? I need to change to something generic like 'Forms'
Anonymous , A measure like this
if(isfiltered(Table[Col]) selectedValue(Table[Col]), "No Value")
refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
2 Replies
- amitchandak
Super User
Anonymous , A measure like this
if(isfiltered(Table[Col]) selectedValue(Table[Col]), "No Value")
refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/