Forum Discussion

xiumi_hou's avatar
xiumi_hou
Icon for Post Partisan rankPost Partisan
6 years ago

How to rename filter value

Dear all,

 

I have a filter, and one selections is "blank()", how can i rename it to "Unknown"? This is a joint relationship(no match), it is not a real a  blank..

Need Help

2 Replies

  • JarroVGIT's avatar
    JarroVGIT
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    Unfortunately, that is not possible as far as I know.

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago
    Hi xiumi_hou ,
     
    Regardless the impact of performance , you can create a new calculated column and use it as a slicer
    Column = IF(ISBLANK(Sheet4[value]),"Unknown",Sheet4[value])
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.