Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

custom column won't show

Hello PBI community,

 

I have a problem with a custom column I have made. The values won't show in the slicer as described: HERE 

 

In Power BI Desktop, i can get the following view: Note here that the status "bogførte" is visible

 

When going to PBI Service, i get the following visual: (please note that the status "Bogførte" is not there.

 

 

 

 

 

 

 

 

How can this be?

I do not know what to do amout this, as there is no problem when doing the analysis in Desktop, but it cannot be shown in service 😞

 

Please help me, I am out of good ideas. 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Tahreem24 ,

     

    I have been in contact with the support team, but ended up solving it my self. 

    By changing the Datatype from text to numbers and back again, and createing a new (but the same) culuom, I could suddenly see the 'lost option' in Power BI Service. 🙂 

11 Replies

  • Anonymous ,

     

    Please double check if any filter is selected while publishing this report to PBI service. OR also check the bookmark if any.

     

    Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User

      Anonymous  if possible so can you just upload the some record lets say 10-20 rows of data by including your Custom Column Status so I will check at my side. (Please mask any confidential data)

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        How do I uploade an example without confidential data?

    • Anonymous's avatar
      Anonymous
      Not applicable

      hi Tahreem24 

       

      There are no filters on the report:

       

      and I haven't used any Booksmarks (haven't figured out how they work).

      The wierd thing is, that it can show me everything in Desktop, but when publishing in Service, it won't show the Bogførte in status. 

       

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User

        Anonymous ,

        Are you using any RLS on your report?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Tahreem24 ,

     

    I have been in contact with the support team, but ended up solving it my self. 

    By changing the Datatype from text to numbers and back again, and createing a new (but the same) culuom, I could suddenly see the 'lost option' in Power BI Service. 🙂