single measure select multiple value shows in one graph
how to show three different values in one graph Redution buckts Ex Rate New Materials scrap values 0.7 0.17 0.45 0.7 0.27 0.35 0.7 0.17 0.45 Valueof Month Values Dec 2020 120 -> starting inventory Jan 121 feb 111 March 121 --> end inventory Graph should like below any idea . thanks in advanceHow to remove Scientific Notation
In my table data looks like Scientific Notation.please find the screen shot. i have used below measure for the graph Total Month = IF(SELECTEDVALUE('Order Table Total'[Sno])="6.Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Order Table Total'[Sno])), SUM('Master Data Base'[Value])) how to trun off scientif notation in my report . i am trying to Format i am getting Error. Looking for support.
Highlight max value of specific rows and column
Hi, DAX driven help: I'd like to highlight the max sum values of a specific row and a specific column to provide orientation in a visually driven table. This will provide an orientation cross of the max value area in the blue area. Each cell in the blue area represents the max sum value for each row or column. Near the periphery of the eye the sum values are less than max. The only way I can think of doing this is adding +100 to each max value in row 0 and column 0. Then with conditional formatting I can highlight the max+100 values with another color resulting in the orientation cross. Currently, it looks like this: Expected from conditional formatting: Close-up of visual table axis: Expected column 0 max values = +100 Expected row 0 max values = +100 Here is the Excel file for anyone to help provide a solution or guidance: https://drive.google.com/file/d/1FvdnXf8kxgQpZlBQD8jgzGXEs47JTzCN/view?usp=sharing Thanks
Calculate datediff between groups and ID
Hi, I need to calculate the DateDiff between different periods grouped by ID and per group. Data looks like this: The measure must caluclate the datediff on planned end date per Project ID and must be grouped on the Stage. So e.g. the measure must show the diff between Project ID AAA and Stage B1 10/07/2021 and Project ID AAA and Stage B1 11/07/2022 which should equal to 366 days. I have a Index Column in the Table historical dates table wich can be used to order the rows inside each project ID.
Measure calculation using different columns based on a value
This is going to be confusing, I apologize in advance. I will try to be as clear as possible. I am trying to create a measure I can use in a visual table that can be filtered by the user. I want that visual to look something like this where $Value is the measure I am trying to create: OrderNbr ShipComplete $Value 12345 Yes $12,000 67891 No $2,000 My question is, is it possible to have the measure sum different column values based on if the order is ShipComplete=Yes or No? In my raw data, each order will have several lines all with differnent $LineValues. In my visual, I want the measure to Sumx(ALL( $LineValues)) IF the order is ShipComplete=Yes regardless of any filters the user applies. If the order is ShipComplete=No I want the measure to only sum the $LineValues of lines that the user filters for. The filters will usually only apply to certain line items on an order so if a filter is applied, the order could get split up in my visual. For example, if the filters result in only 2 of the 5 line items on an order and the order is ShipComplete=Yes then I want the visual to show the sum of all 5 line item values but if the order is ShipComplete=No then I want the visual to show the sum of only the 2 line item values. UPDATE: This is even more complex than I originally thought. My data has 3 levels to it: Order, TopLevel, Item. Each Item has a price associated with it and also have the values which the user will be filtering based on in my data. I want the resulting visual to show a sum on the Order level (as seen in above table). If the order is ship complete I want to see the sum of all Item values in that order regardless of filters. If the order is not ship complete but the item has a TopLevel, I want to see the sum of all Item values in that TopLevel. Otherwise I only want to see the sum of Item values that the user has filtered for. Below is a better example of my raw data set where Color is what the user will filter the visual on. Order# TopLevel# Item# Ship Complete Item$ Color 1 100 101 No 5 red 1 100 102 No 7 green 1 100 103 No 5 green 2 104 Yes 10 red 2 105 Yes 4 green 3 200 106 No 5 red 3 200 107 No 3 green 3 201 108 No 5 red 3 201 109 No 3 green 3 110 No 10 green From this data I want a visual that results in exactly the following (assuming the user filters for "red") Order# Ship Complete Total Value 1 No 17 2 Yes 14 3 No 16 Is this even possible??
