Forum Discussion
Solved
Selection
I have a dashboard where the end-user can select one of several options to filter a table. I also have a label that shows what the current selection is. I need a way to make the label say ALL when no...
So you can do something like:
Label Measure = IF(HASONEVALUE('Table'[Column]),MAX('Table'[Column),"All")For a really fancy version of this: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer-Title-Measure-Ever/td-p/429587
So you can do something like:
Label Measure =
IF(HASONEVALUE('Table'[Column]),MAX('Table'[Column),"All")
For a really fancy version of this: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer-Title-Measure-Ever/td-p/429587