Creating Custom Subrows as Percentage Changes
Hi, I need to add a subrow that calculates of percentage change for between specific 2 different time periods as below. Type Sum of Revenue Yesterday 229,925.28 SDLM 196,666.63 Variance1 1.17 Last 7 days 1,348,787.62 7 days SPLM 1,325,468.28 MTD 4,296,514.29 SPLM 4,280,047.93 Variance2 1.00 YTD 13,437,909.68 All 54,389,536.48 I created the date periods before and they are dynamic by slicers, so I'm happy with this format because there are lots of measures except for Revenue. I have tried to create matrix as below but it shows subtotals, it might give a clue, You can find the sample report here: Sample_report Thank you, VK
Sum of Remaining Mini Values based on Department and Type in Matrix
Hello PBI Community, I'm working on report to calculate expenses status based in Departmnet and Type as in screenshot below. Due to remaining calculation after each sepnding and budget type I need to add remaining in Matrix visula, however the sum of remaining is worng it should be Sum of Mini values per each expense type in TOTAL without effect the remaining column rows values as in last column. Attached the excel samplefile, please support: Sample excel link: Link Thanks,
Filter Matrix visual based on the current level In Scope, without affecting not in Scope values.
Hi All, I'm trying to filter a Matrix visual based on a measure value category (segmenting the measure values). the problem is that the filter is filtering all rows in the visual, while the desired result would be just filtering the rows in the current context (i.e. based on the currently visible hierarchy of the matrix). For Example, the delta% value of OFQ subsystem was 60.6% before filtering, and when a filter was applied the value changed to 79.7%. what is happening is that the filter is filtering out the rows in the next level ([Area] in this case); thus the value changes accordingly. The desired output is to keep the 60.6% value as it's. and this should by dynamic based on the currently displayed level. After a long research and trials, I've tried to detect the current displayed level using ISINSCOPE/HASONEVALUE functions, then exclude next level values with ALLSELECTED/REMOVEFILTERS. but it doesn't seem to detect the current level in scope correctly. Hope you can help me here. Please note that I can't create the category filter in a column since all of my values are based on slicers selections; thus, I can't summarize the data in a table or a column. that's why I had to use a measure and add it to visual filters. here is a sample report that mimics what I'm trying to do: question.pbix Thanks a lot,,
Subject: How do I show an independent value of a subtask (hierarchy) in a matrix ?
Hello, I am trying to create a matrix where the rows are a set of tasks that need to be completed. The tasks have subtasks. Both the tasks and the subtasks have statuses (that are independent of one another, i.e. task 1 (level 1) can be in progress, but a subtask can be completed). The statuses (icons) are the values in the matrix. However, I do not know how to set up the excel sheet and/or the hierarchy, to show these independent statuses. Most hierarchy examples I have seen only talk about numerical data, but this is non numerical. Statuses include: Not Started, In Progress, Completed, At Risk, Delayed. Below is the example of the matrix. Here, the main task can have a different status as compared to the subtask's status. I know that ISINSCOPE needs to be used but do not know how to exactly resolve the issue. Can someone please help me write this code to achieve the end result? Any help would be appreciated. Thank you
