User Profile
AlexJB
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Search function and Select all function in slicer not working together?
Hello everybody, I am seeing old questions about this but not really if it is fixed or not. I am using a Slicer with search bar and I would love to have the Select all function when there is searched in this slicer. Is this possible? The select all dissapears whenever the searched function is used. Thanks in advance Alex502Views0likes2CommentsProduct list, lookup successor that is active
Hello, I have the following problem. I have a product list where I need to make a search visual for where they can look up any product and then it should show an active successor(s). Although this product can be a few years old. For example I made a list below. If someone searches for Product 112 it should show product 115 AND 122 because at some point they are the successors of product 114 which is the successor of 113 and before that 112. If someone looks up product 132 it should show 134 because 134 is the successor of 133 which is the successor of 132. IF someone looks up 133 then it has to show 134. Product Successor predecessor Status 112 113 Expired 113 114 112 Expired 114 115 113 Expired 115 - 114 Active 122 - 114 Active 132 133 - Expired 133 134 132 Expired 134 - 133 Active Is there a way to do this in powerbi? I hope someone is able to help me.Solved481Views0likes1CommentRe: Need first date from first schedule line in column to be able to create right table. not sure how.
I fixed it by creating a new table with only Ordernr + temid and the newly created First order date. Then I removed all rows with null as value. To use it in visual I linked my date table to this one and on date level. then another relation from order+temid to order+temid relation to the first table I got the same results as using the data without the extra table and only using the following formula. so for my report the extra step wasnt needed, I still do use it for future calculations. = Table.AddColumn(#"Inserted Merged Column", "First order date", each if [Schedule line] = 1 then [conf date] else null)497Views0likes0CommentsRe: Need first date from first schedule line in column to be able to create right table. not sure how.
I do not see how this works. For now I have = Table.AddColumn(#"Inserted Merged Column", "First order date", each if [Schedule line] = 1 then [conf date] else null) Although this gives for every other schedule line after one null as data. That data has to give the same data as was given in the line of schedule line 1.. So it has to look up the value of the combi order+itemid + schedule line = 1 and give that date for all the other lines.. but I cant get this to work. tried several things already.507Views0likes1CommentNeed first date from first schedule line in column to be able to create right table. not sure how.
Hi, So below u see some demo data that is needed for this question. I already made a new column Ordernr + itemid to create a unique key so this is also able to be used. what I want to achieve is in the last column. I want for each order+itemid the first scheduled conf date. so where schedule line is 1 I want that date for each schedule line. It is not the first date because it is possible that the second schedule line is earlier then the first. What I want is to use this date as the first order date for this product. For some reason it is difficult to get this in a different way. In the end I need to create a date table from these dates and then connect it to this first order date. to be real honest I need to get these schedules line out of the file. but there is alot of other data on different schedule lines which I need. I hope I am clear. thanks in advance Ordernr itemid schedule line conf date (new column created) = ordernr +temid What I want to get: first order date 10010 10 1 10-01-2023 1001010 10-01-2023 10010 10 2 12-01-2023 1001010 10-01-2023 10010 10 3 12-02-2023 1001010 10-01-2023 10010 20 1 10-01-2023 1001020 10-01-2023 10010 30 1 12-01-2023 1001030 12-01-2023 10020 10 1 14-01-2023 1002010 14-01-2023 10020 20 1 15-01-2023 1002020 15-01-2023 10020 20 2 12-01-2023 1002020 15-01-2023Solved548Views0likes3CommentsChange in percentage from month before
Hi, For a report we want to show qty's per month in a graph. We have quantities on Y-axis, months on X-axis and each line is a year. Now we want to show the change in quantities in percentage from the month before. Although I think I have a problem with the data. I made example data, these are the actual columns I have. As you can see not every month has a quantity. This means when I just do a month - 1 formula I wont get all data because there is a possibility that product 202 has quantities in february but not in march so the formula won't find the data. So I think I had to make a new table with a possible combinations of customer, product, year and month and then do a lookup for the quantities. If there is no quantity then show 0. The file is quite big (~400.000 lines of data), when I tried to make all possible combinations powerbi stops working. Do you guys know some way to do this in powerbi or do I need to work with other programs to create the data I need (if it is needed)? Or is my computer just to slow. Customer Product Year Month Qty DE1 202 2018 1 10 DE1 202 2018 2 4 DE1 202 2018 5 8 DE1 202 2018 6 6 DE1 202 2018 10 7 DE1 202 2018 11 8 DE1 202 2018 12 6 DE1 202 2019 1 5 DE1 202 2019 2 10 DE1 202 2019 3 12 DE1 202 2019 4 11 DE1 202 2019 5 6 DE1 202 2019 6 8 DE1 202 2019 7 7 DE1 202 2019 8 10 DE1 202 2019 9 1 DE1 202 2019 10 2 DE1 202 2019 11 2 DE1 202 2019 12 10 DE1 203 2018 1 10 DE1 203 2018 2 12 DE1 203 2018 3 11 DE1 203 2018 4 11 DE1 203 2018 7 10 DE1 203 2018 8 9 DE1 203 2018 9 8 DE1 203 2018 11 7 DE1 203 2018 12 10 DE1 203 2019 1 12 DE1 203 2019 2 11 DE1 203 2019 5 1 DE1 203 2019 6 10 DE1 203 2019 8 12 DE1 203 2019 9 1 DE1 203 2019 12 5Solved468Views0likes2CommentsMaster data file and master date file, can't link both. Suggestions?
Good afternoon, I am looking for a solution for the a problem with a date table and a master data file. I have linked all my data files to a master data file because the files themselves would be too big to handle. Although now I also want to filter on months/ years in the visuals. To do this I need a master date file. But I cannot link this to all the files aswell. I cannot make all the links active. Which is ofcourse normal. But there must be some kind of solution for this. I hope it is clear. See below screenshot what I actually want but whats ofcourse impossible. I can't include dates in the master data file because thats filled with product information. thanks in advance, AlexSolved560Views0likes1CommentGive two columns same name to be able to filter
Good day everyone, I couldn't find an answer to the following question hopefully you guys are able to help me. I have a table with the following sales data product 202101 202102 202103 202201 202202 202203 1 20 10 23 24 15 20 2 30 40 40 34 40 40 As you can see some headers are related to the month in a certain year, so second column is januari 2021 after februari 2021 and so on. There are also colummns for januari 2022 and februari 2022. Is there a possibility to make a measure to give these columns just the name 'januari' or 'februari'? I want this so I can place a filter in the report to only show data from januari, but then from 2021 and 2022. Hope you can help me!Solved723Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.