User Profile
clim2f88j
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Top N and Others
I've watched and read a bunch of different ways to do this and still can't figure it out. I have a list of departments that one of them is picked when working a complaint. Therefore, to get the total count for each department that was picked, I do a DISTINCTCOUNT(Department). I can create a pie chart that will show the percentage of complaints by department, by using the department in the value as well and selecting it as count. All the videos i watched and post i read, are using a "sales" value which doesn't excist in my data, and i haven't been able to find a way around this. I want to be able to do a top N, lets say top 3, and then in the graph show "Others" which is the total of the remaining departments. Department A B C D E F1.6KViews0likes5CommentsNavigation Landing Page in App
Hello everyone, I created an app for our workspace so its easier to locate reports. But i need help with a landing page. I don't want to create a dashboard and use tiles to locate and open the reports. I don't like the look of them. What i did is, i created a new report with 4 different categories and users can click the corresponding one and they will be able to see all the reports that belong for that category and a description of each. This report is the first one they see when they open the tab, so it looks like the home page. In each table, i added a hyperlink to the report names so they can open the reports. The report will open in the app but they open in a new tab. To open the reports in the same tab, they have to select them from the drowpdown menus that i added in the apps content setting (left side). My question is, is there a way to open on the same app tab the reports when the user is selecting them from the tables i created from my navigation report?580Views0likes1CommentCreating a directory or "home page" to reports
Hello everyone, our team has a lot of publish reports and sometimes its hard to locate the one we are looking for. Is there a way to create folders in our teams page to separate the reports? Or is there a way to create a report that would be like a directory or the home page for our team? Meaning that from this main report, we could separe each report by section and then select the one we need to open and it will navigate the user to it. Thank you!Solved560Views0likes2CommentsRe: Index Column Based on ID and Date
Thank you for helping me out but i get the following error with that DAX: EARLIER/EARLIEST refers to an earlier row context which doesn't exist. In your example, the AAA ID with the 3/7/2023 date have the same index. I need them to be different.4.1KViews0likes1CommentRe: Index Column Based on ID and Date
Thank you! That worked for the most part, but something i didn't account for is what if the dates are the same? Right now if the dates are the same for the same ID then they are getting the same index number. My dates don't have a timestamp. If they have the same date/ID then i don't care which one gets the lower/higher index.4.2KViews0likes3CommentsIndex Column Based on ID and Date
Hello everyone, I need to add an index column based on consumers ID and date. Data: ID Date AAA 1/1/23 AAA 3/7/23 AAA 4/18/23 BBB 12/19/22 BBB 4/5/23 CCC 7/9/23 CCC 9/1/23 What i'm looking for: ID Date Index AAA 1/1/23 1 AAA 3/7/23 2 AAA 4/18/23 3 BBB 12/1/22 1 BBB 4/5/23 2 CCC 7/9/23 1 CCC 9/1/23 2 The index column would tell me how many cases we have for that ID and then give it a value based on the date. So the oldest date would get a 1 and the next date a 2, and so on. But i need it to restart when it gets to the next ID. Thank you all!4.2KViews0likes7CommentsAverage per month in visual card
Hello everyone, I need to show the data below in a table. There are 4 users (A,B,C,D) that worked cases between January and March. User January February March A 5 3 2 B 4 2 2 C 5 5 4 D 10 8 4 I need to add a column that shows how many cases everyone worked for that month and another colum for how many each user worked that year, like this: User January February March Total Year A 5 3 2 10 B 4 2 2 8 C 5 5 4 14 D 10 8 4 22 Total 24 18 12 54 And once that's done, then i need a visual card that shows the average per month for all users. So if January is selected then the card should show: 6 Power query doesn't let me add totals down a column. I tried to do the List.Sum but it adds across users instead of each month. Thank you for your help!415Views0likes1Comment
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.