- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
I then uplode this to Power BI Service. When I do this, the option to choose "Bogførte" is gone;
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
07-11-2024 10:27 AM | |||
08-25-2024 10:54 AM | |||
05-24-2024 05:32 AM | |||
11-13-2023 09:20 AM | |||
02-13-2024 01:13 AM |
User | Count |
---|---|
101 | |
74 | |
43 | |
38 | |
31 |
User | Count |
---|---|
166 | |
90 | |
65 | |
46 | |
43 |