Forum Discussion

ohohbudi's avatar
ohohbudi
Frequent Visitor
9 years ago

[October Release] Bug? Blank Slicer

Hi guys, i want to ask (i use Power BI October Release). When i made a slicer for my dimension table (Dimension Branch) or other dimension table, why it's showed a (Blank) value in the slicer? Actually i have no blank data or blank value in my dimension tables, I am really confused why this is always happen. Anyone could help me? Thanks

 

  

Need Help
Show and Tell

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi ohohbudi,

     

    Which version of PowerBI desktop do you use? If it is earlier than June release, you can try this workaround to exclude the (Blank). 

    1. convert the Slicer to a Table
    2. go to the Visual Level Filters
    3. select is not blank
    4. convert back to Slicer

     

    Please refer to this topic . Besides, someone has submitted this issue to Microsoft, you can go to this page and vote it up.

     

    Thanks,
    Yuliana Gu

    • ohohbudi's avatar
      ohohbudi
      Frequent Visitor
      9 years ago

      I use October release version for my Power BI, that's why I am totally confused why this newest version could caused this bug. I tried your steps already but there are no changes until now. 

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi ohohbudi,

         

        It looks like an issue that some other users also come across. This issue has been submitted at this page , you can vote it up. Appreciate for your understanding.

         

        Thanks,
        Yuliana Gu