Reply
avatar user
Anonymous
Not applicable

Custom column data doesn't show in service

Hello fellow PBI's 😄

 

I have a problem with a custom column I have created. 

I have two columns - One telling me if the hours registred by an amployee is either "Open", "Send" or "accepted". This coolumn is called "Status". Then I have another column telling me, if the hours have been logged into our system or not (registred by the executive) (in Danish this is called Bogførte). This is a true/false column and it is calles "Posted".

 

I have then created another column, as I wish to see if the Accepted hours have also been logged into the system. For this, I have used the DAX:

Status sand = IF('Timer pr dag'[Posted]="TRUE";"Bogført";'Timer pr dag'[Status])

 

In Power BI Desktop, it will now give me the possibility to check these, useing a slicer

bogførte.PNG

I then uplode this to Power BI Service. When I do this, the option to choose "Bogførte" is gone;

status.PNG

 I have made other changes to the report after this, and these changes have been implemented in the report, both on Desktop and on Service. But it seems like it just won't let me update the slicer menu.

 

Please help, I have tried everything I know.

2 REPLIES 2
dax
Community Support
Community Support

Hi ams,

I can't reproduce your problem in my environment. If you create a new report just have slicer in it and use your calculated column in slicer, upload it in service, will this work or not. If this work, I think you need to re-upload your original report to see whether it work or not. Or you could re-add slicer in service(edit report in service) to see whether it work or not.

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user
Anonymous
Not applicable

@dax , thank you for your answer. It does not help, unfortunally 😞

I have tried to remove the slicer from the report, uploade it, open the report and re-ad the slider in Service, but I still can't get Power BI to show "Bogførte" as an option.

 

You wrote that I should re-uploade the original report. What do you mean by this? I have tried to re-publish the report multiple times, without any help. 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)